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