select a.companyId, cho.cho_name from tbl_LIB_Accounts a inner join tbl_LIB_Companies c on c.companyId = a.companyId inner join tbl_CHO_Operators cho on c.companyPKeyId = cho.cho_id and c.companyPType = 'CHO' group by a.companyId, cho.cho_name order by cho.cho_name select moduleId from tbl_LIB_Accounts where fspro_userId = and companyId = and moduleId = 63 delete from tbl_LIB_Accounts where fspro_userId = and companyId = and moduleId = 63 select moduleId from tbl_LIB_Accounts where fspro_userId = and companyId = and moduleId = 86 insert into tbl_LIB_Accounts ( fspro_userId, companyId, moduleId ) values ( #attributes.userId#, #qmd_accounts.companyId#, 86 )