select
ELVIS_COMPANY_LOGO.sz_company as Posid_company,
ELVIS_COMPANY_LOGO.sz_logo as Posid_logo,
elvis_main_hierarchy.N0_COMPANYLOGO_ID as Posid_companylogoid,
elvis_main_hierarchy.N0_TERMINAL_ID as Posid_pos,
elvis_main_hierarchy.N0_UNIQUE_STR_NO as Posid_store,
n0_current_xact_no as Posid_xact from elvis_main_hierarchy, ELVIS_COMPANY_LOGO where
sz_company = 'CCCC' and sz_logo='LLLL' and
elvis_main_hierarchy.N0_COMPANYLOGO_ID = ELVIS_COMPANY_LOGO.N0_COMPANYLOGO_ID and
n0_unique_str_no=SSSS and
n0_terminal_id=PPPP

