update elvis_main_hierarchy set n0_current_xact_no = elvis_main_hierarchy.n0_current_xact_no + 1 
from elvis_main_hierarchy as ff
join ELVIS_COMPANY_LOGO ON
ff.n0_companylogo_id = ELVIS_COMPANY_LOGO.n0_companylogo_id and
ELVIS_COMPANY_LOGO.sz_company = 'CCCC' and
ELVIS_COMPANY_LOGO.sz_logo='LLLL'
where elvis_main_hierarchy.n0_unique_str_no=SSSS
and elvis_main_hierarchy.n0_terminal_id=PPPP
