SELECT IV10402.PRCSHID, IV10402.EPITMTYP, IV10402.ITEMNMBR, IV00101.ITEMDESC, IV10402.UOFM, IV10402.QTYFROM, IV10402.QTYTO, IV10402.PSITMVAL, IV10402.EQUOMQTY,
IV10402.QTYBSUOM, IV10402.SEQNUMBR, IV10402.DEX_ROW_ID, IV00101.ITMCLSCD, IV10401.PRODTCOD
FROM
IV10402 INNER JOIN
IV00101 ON IV10402.ITEMNMBR
= IV00101.ITEMNMBR
INNER JOIN
IV10401 ON IV10402.PRCSHID
= IV10401.PRCSHID
AND IV10402.ITEMNMBR
= IV10401.ITEMNMBR
No comments:
Post a Comment