/* Formatted on 2012/04/11 11:05 (Formatter Plus v4.8.8) */
SELECT distinct prlnty
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 = 'LY' and trim(drky) = (trim(prlnty)))
No comments:
Post a Comment