select i.ITEM_CODE as CODE
,CASE
    WHEN i.ITEM_NAME = ih.ITEM_NAME THEN null
    ELSE i.ITEM_NAME
 END
as NAME
from ITEM i left join ITEM_HISTORY ih on i.ITEM_CODE = ih.ITEM_CODE
order by CODE desc