SELECT *
FROM (
SELECT
ITEM.ITEM_CODE AS CODE
,ITEM.ITEM_NAME AS NAME
,'ADDED' AS COMP_RSLT
FROM ITEM
LEFT OUTER JOIN ITEM_HISTORY
ON ITEM_HISTORY.ITEM_CODE = ITEM.ITEM_CODE
WHERE ITEM_HISTORY.ITEM_CODE IS NULL
UNION ALL
SELECT
ITEM.ITEM_CODE AS CODE
,ITEM.ITEM_NAME AS NAME
,'UPDATED' AS COMP_RSLT
FROM ITEM
LEFT OUTER JOIN ITEM_HISTORY
ON ITEM_HISTORY.ITEM_CODE = ITEM.ITEM_CODE
WHERE ITEM_HISTORY.USER_UPDATE_DATETIME <> ITEM.USER_UPDATE_DATETIME
UNION ALL
SELECT
ITEM_HISTORY.ITEM_CODE AS CODE
,ITEM_HISTORY.ITEM_NAME AS NAME
,'DELETED' AS COMP_RSLT
FROM ITEM_HISTORY
LEFT OUTER JOIN ITEM
ON ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
WHERE ITEM.ITEM_CODE IS NULL
) AS COMP_RSLT_TABLES
ORDER BY COMP_RSLT_TABLES.CODE DESC
;