select 
        ITEM_HISTORY.item_code as CODE,
        ITEM_HISTORY.ITEM_name as NAME,
        "DELETED" as COMP_RSLT
    from 
        ITEM_HISTORY
        left join ITEM using(item_code)
    where
        ITEM.item_code is null
union
    select 
        ITEM.item_code as CODE,
        ITEM.ITEM_name as NAME,
        "ADDED" as COMP_RSLT
    from 
        ITEM
        left join ITEM_HISTORY using(item_code)
    where
        ITEM_HISTORY.item_code is null
union 
    select 
        ITEM.item_code as CODE,
        ITEM.ITEM_name as NAME,
        "UPDATED" as COMP_RSLT
    from 
        ITEM
        inner join ITEM_HISTORY using(item_code)
    where
        ITEM_HISTORY.USER_UPDATE_DATETIME <> ITEM.USER_UPDATE_DATETIME
order by CODE desc