SELECT A.bs,A.val,A.key_,A.otd,A.numb,A.summ_i,A.summ_iv,B.prizn,B.open_date,C.* FROM t_p A LEFT JOIN L_po1 B ; ON A.bs+A.val+A.key_+A.otd+A.numb=B.bs+B.val+B.key_+B.otd+B.numb LEFT JOIN L_recli C; ON B.kod_client=C.kod_client WHERE A.summ_i>0 AND ; (Left(A.bs,3)='423' or Left(A.bs,3)='426' or Left(A.bs,3)='522' or ; ((A.bs='40806' or A.bs='40809' or A.bs='40812' or A.bs='40813' or A.bs='40814' or A.bs='40815') and B.prizn like '%F_%') ; or A.bs in ('40803','40817','40820','47603','47605','52404')) ; INTO table SYS(2023)+"\L_dog012" ORDER BY C.kod_client