select
    item.ITEM_CODE as CODE,
    CASE
    when item_history.item_code 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 join item_history on item.item_code = item_history.item_code
order by item.item_code desc;