SELECT item.item_code CODE
     , CASE
           WHEN hi.item_code IS NULL OR item.item_name <> hi.item_name THEN item.item_name
           ELSE NULL END AS NAME

FROM item
     LEFT JOIN item_history hi ON item.item_code = hi.item_code
ORDER BY 1 DESC;