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 outer join item_history using(item_code)
order by 1 desc;