SELECT
    i.item_code CODE
    ,CASE 
        WHEN i.item_name != IFNULL(ih.item_name, i.item_name) THEN i.item_name
        ELSE NULL
    END AS NAME
FROM
    item i
    LEFT JOIN item_history ih
    ON i.item_code = ih.item_code
ORDER BY
    i.item_code DESC