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
Comments
0 B
|👍
/👎
0 B
|0 👍
/0 👎
0 B
|👍
/👎