select
    case 
        when ITEM.ITEM_CODE is null then ITEM_HISTORY.ITEM_CODE
        else ITEM.ITEM_CODE
    end as CODE
    ,case 
        when ITEM.ITEM_NAME is null then ITEM_HISTORY.ITEM_NAME
        else ITEM.ITEM_NAME
    end as NAME
    ,case
        when ITEM_HISTORY.USER_UPDATE_DATETIME is null then "ADDED"
        when ITEM.USER_UPDATE_DATETIME > ITEM_HISTORY.USER_UPDATE_DATETIME then "UPDATED"
        when ITEM.ITEM_CODE is NULL and ITEM_HISTORY.ITEM_CODE is not null then "DELETED"
        else NULL
    end AS COMP_RSLT
from 
    ITEM_HISTORY
full outer join ITEM
on ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
where COMP_RSLT is not NULL
order by CODE desc