select t1.ITEM_CODE as CODE,
CASE WHEN t2.ITEM_NAME IS NULL THEN 
t1.ITEM_NAME
when t1.ITEM_NAME <> t2.ITEM_NAME
then t1.ITEM_NAME else NULL end as NAME
from ITEM as t1 Left JOIN ITEM_HISTORY as t2 ON t1.ITEM_CODE = t2.ITEM_CODE
order by CODE desc;