select
    i.item_code as CODE,
    nullif(i.item_name,ih.item_name) as NAME
from
    item as i
left join
    item_history as ih on ih.item_code = i.item_code
order by
    i.item_code desc
    
;