Wednesday, April 11, 2012

Linetypes not in UDC 55|LY


/* 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