select
    i.item_code as CODE,
    case
        when i.item_name = ih.item_name then null
        else i.item_name
        end as NAME
from
    item as i
left join
    item_history as ih
on
    i.item_code = ih.item_code
order by
    i.item_code desc