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