CryptoJones Aug 6th, 2019 78 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT CAST(AMFLIB7.ITMRVA.ITNBR AS CHAR(16) ccsid 37) AS "ItemNumber", CAST(AMFLIB7.ITMRVA.ITDSC AS CHAR(64) ccsid 37) AS "Description", AMFLIB7.ITRBPR.BZANVA AS "Price"
- FROM AMFLIB7.ITMRVA
- INNER JOIN AMFLIB7.ITRBPR ON AMFLIB7.ITRBPR.ITNBR = AMFLIB7.ITMRVA.ITNBR
- WHERE AMFLIB7.ITMRVA.ITNBR = '350212'
- ORDER BY AMFLIB7.ITRBPR.BZBLDT DESC
- FETCH FIRST 1 ROWS ONLY
RAW Paste Data