SELECT
  item.ITEM_CODE AS CODE
FROM
  ITEM item
  CROSS JOIN ITEM_HISTORY hist ON item.ITEM_CODE = hist.ITEM_CODE
ORDER BY
  item.ITEM_CODE desc;