select TA001,TA002,TA006,TA034 from MOCTA where TA001+TA002 not in (select TA001+TA002 from SFCTA)
AND TA011 ='1' or TA011='2' or TA011='3'
ORDER BY TA006,TA001,TA002 ASC
AND TA011 ='1' or TA011='2' or TA011='3'
ORDER BY TA006,TA001,TA002 ASC
--try
select TA001,TA002,TA006,TA034 from MOCTA where not exists (select 1 from SFCTA s where MOCTA .TA001=s.TA001 and MOCTA .TA002=s.TA002 )AND TA011 ='1' or TA011='2' or TA011='3'
ORDER BY TA006,TA001,TA002 ASC