SELECT
    ITEM_CODE AS CODE,
    CASE
        WHEN ITEM_HISTORY.ITEM_NAME IS NULL THEN ITEM.ITEM_NAME
        WHEN ITEM.ITEM_NAME = ITEM_HISTORY.ITEM_NAME THEN NULL
        ELSE ITEM.ITEM_NAME
    END AS NAME
FROM
    ITEM
    LEFT JOIN ITEM_HISTORY
        USING (ITEM_CODE)
ORDER BY
    ITEM_CODE DESC