select top 10 * from TB_directory_EXH as A join TB_COMPANY_EXH as B on A.ref_idx = B.idx join TB_COMPANY_item_sub_EXH C on C.ref_idx = A.ref_idx where C.idx in (SELECT idx FROM TB_COMPANY_item_sub_EXH C WHERE C.ref_idx = A.ref_idx and C.apply = 'A') and isnull(del,'') <> 'Y' and syear = '2022' and state = 'Y' order by B.company_name_eng asc K-Mtech 2022