Advertisement
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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement