select
    ITEM_CODE as 'CODE',
    ITEM_NAME as 'NAME',
    'ADDED' as 'COMP_RSLT'
from
    ITEM
where
    ITEM_CODE IN(
        select ITEM_CODE from ITEM
        EXCEPT
        select ITEM_CODE from ITEM_HISTORY
    )
UNION
select
    ITEM_CODE as 'CODE',
    ITEM_NAME as 'NAME',
    'UPDATED' as 'COMP_RSLT'
from
    ITEM
where
    ITEM_CODE IN(
        select 
            N.ITEM_CODE
        from
            ITEM as N
        join
            ITEM_HISTORY as O on N.ITEM_CODE = O.ITEM_CODE
        where
            N.USER_UPDATE_DATETIME <> O.USER_UPDATE_DATETIME
    )
UNION
select
   ITEM_CODE as 'CODE',
    ITEM_NAME as 'NAME',
    'DELETED' as 'COMP_RSLT'
from
    ITEM_HISTORY
where
    ITEM_CODE IN(
        select ITEM_CODE from ITEM_HISTORY
        EXCEPT
        select ITEM_CODE from ITEM
    )
order by
    CODE DESC