SELECT 
i.item_code code,
CASE 
WHEN ih.item_name is null THEN i.item_name
WHEN i.item_name == ih.item_name then NULL
ELSE i.item_name
END NAME


from

ITEM i
left join ITEM_HISTORY ih
on i.item_code=ih.item_code

order by i.item_code desc