SELECT
-- ITEM_CODE AS CODE
-- ,ITEM_NAME AS NAME
*
FROM
ITEM AS I
INNNER JOIN ITEM_HISTORY AS H
I.ITEM_CODE = H.ITEM_CODE
ORDER BY
ITEM_CODE DESC