SELECT
	ITEM_CODE AS CODE,
	ITEM_NAME AS NAME,
	'ADDED' AS COMP_RSLT
FROM
	ITEM 
WHERE
	NOT EXISTS(SELECT 1 FROM ITEM_HISTORY WHERE ITEM_CODE = ITEM.ITEM_CODE)
UNION
SELECT
	ITEM_CODE AS CODE,
	ITEM_NAME AS NAME,
	'UPDATED' AS COMP_RSLT
FROM
	ITEM 
WHERE
	EXISTS(SELECT 1 FROM ITEM_HISTORY WHERE ITEM_CODE = ITEM.ITEM_CODE AND USER_UPDATE_DATETIME <> ITEM.USER_UPDATE_DATETIME)
UNION
SELECT
	ITEM_CODE AS CODE,
	ITEM_NAME AS NAME,
	'DELETED' AS COMP_RSLT
FROM
	ITEM_HISTORY 
WHERE
	NOT EXISTS(SELECT 1 FROM ITEM WHERE ITEM_CODE = ITEM_HISTORY.ITEM_CODE)
ORDER BY
	CODE DESC