select
    IT.item_code CODE,
    IT.item_name NAME,
    'ADDED' COMP_RSLT
from
    item IT
    full outer join item_history HS on IT.item_code = HS.item_code
where
        HS.item_code is null
union
select
    IT.item_code CODE,
    IT.item_name NAME,
    'UPDATED' COMP_RSLT
from
    item IT
    full outer join item_history HS on IT.item_code = HS.item_code
where
        IT.user_update_datetime != HS.user_update_datetime
union
select
    HS.item_code CODE,
    HS.item_name NAME,
    'DELETED' COMP_RSLT
from
    item IT
    full outer join item_history HS on IT.item_code = HS.item_code
where
    IT.item_code is null
order by
    CODE desc