select ITEM.ITEM_CODE CODE,
        CASE WHEN ITEM.ITEM_NAME = ITEM_HISTORY.ITEM_NAME THEN 'NULL'
        WHEN ITEM.ITEM_NAME != ITEM_HISTORY.ITEM_NAME THEN ITEM.ITEM_NAME
        ELSE ITEM.ITEM_NAME
        END NAME
from ITEM
left outer join ITEM_HISTORY
on ITEM_HISTORY.ITEM_CODE = ITEM.ITEM_CODE
order by CODE desc;