select a.ITEM_CODE AS CODE,
(case when a.ITEM_NAME = b.ITEM_NAME then 'NULL'
else a.ITEM_NAME end )as NAME
from ITEM a
left join ITEM_HISTORY b
on a.ITEM_CODE=b.ITEM_CODE
order by CODE DESC