SELECT *
FROM proddta.f43121, proddta.f76432
WHERE prdoco = pjdoco
AND prdcto = pjdcto
AND prkcoo = pjkcoo
AND prlnid = pjlnid
AND prsfxo = pjsfxo
AND prmatc IN ('1', '2')
and not exists (select * from prodctl.F0005 where drsy = '55' and drrt = 'FA' and trim(drky) = (trim(pjbnop)||trim(pjbsop)))
No comments:
Post a Comment