select i.item_code as CODE ,
    case 
        when h.item_name is null then i.item_name
        when h.item_name <> i.item_name then  i.item_Name
        else NULL 
    end as NAME
from item as i left outer join item_history as h on code = h.item_code order by i.item_code desc;