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