SELECT
    IT.ITEM_CODE AS 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;