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