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