SELECT
    ITEM.ITEM_CODE AS CODE,
    NULLIF(ITEM.ITEM_NAME, ITEM_HISTORY.ITEM_NAME) AS NAME
FROM ITEM
LEFT OUTER JOIN ITEM_HISTORY
ON ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
ORDER BY ITEM.ITEM_CODE DESC;