select
    I.ITEM_CODE CODE,
    case IH.item_name
        when I.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
    CODE desc