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_HISTORY.ITEM_CODE = ITEM.ITEM_CODE
        --ON ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
ORDER BY
    ITEM.ITEM_CODE DESC;