select
    item.item_code as CODE
    ,
    case
        when item.item_name = his.item_name then NULL else item.item_name
    end as NAME
from
    item
    left outer join item_history as his
        on item.item_code = his.item_code
order by
    CODE desc
;