select
    I.ITEM_CODE as CODE
    ,case
        when I.ITEM_NAME=H.ITEM_NAME then 'NULL'
        else I.ITEM_NAME
    end as NAME
from
    ITEM I
    left outer join 
        ITEM_HISTORY H 
        on
            I.ITEM_CODE=H.ITEM_CODE
order by 1 desc