select 
i.ITEM_CODE as CODE,
case
when i.ITEM_NAME != h.ITEM_NAME then i.ITEM_NAME
when h.ITEM_NAME is null then i.ITEM_NAME
else NULL
end as NAME
FROM ITEM i left join ITEM_HISTORY h on i.ITEM_CODE = h.ITEM_CODE
order by 1 desc