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 i.item_code = ih.item_code
order by
    i.item_code desc
   
;