Thursday, September 29, 2011

Compare Transaction Nature


SELECT prkcoo, prdoco, prdcto, prlnid, prnlin, prsfxo, prmcu, fdbnnf,  prdcto, pjbnop, pjbsop,fdbnop, fdbsop FROM proddta.F43121, proddta.F76432, proddta.F7611B WHERE
prdoco = pjdoco AND
prdcto = pjdcto AND
prkcoo = pjkcoo AND
prsfxo = pjsfxo AND
prlnid = pjlnid AND
PrDOCO = FDDOCO AND
PRDCTO = fdPDCT AND
PRLNID = FDLNID AND
prnlin = fdnlin AND
prsfxo = fdsfxo AND
prdgl <= 111243 AND
prmatc = 1 AND
pjbnop||pjbsop <> fdbnop||fdbsop

No comments:

Post a Comment