SELECT
	ITEM_CODE AS CODE,
	ITEM_NAME AS NAME,
	COMP_RSLT
FROM
		(SELECT ITEM_CODE, ITEM_NAME, 'ADDED' AS COMP_RSLT
		FROM (SELECT * FROM ITEM_HISTORY EXCEPT SELECT * FROM ITEM)
	UNION
		SELECT ITEM_CODE, ITEM_NAME, 'DELETED' AS COMP_RSLT
		FROM (SELECT * FROM ITEM EXCEPT SELECT * FROM ITEM_HISTORY)
	UNION
		SELECT H.ITEM_CODE, H.ITEM_NAME, 'UPDATED' AS COMP_RSLT
		FROM ITEM_HISTORY H
		WHERE H.USER_UPDATE_DATETIME <> (SELECT I.USER_UPDATE_DATETIME FROM ITEM I WHERE I.ITEM_CODE = H.ITEM_CODE))
ORDER BY
	CODE DESC;