SELECT *
FROM 
(
	-- 削除
	SELECT 
		ITEM_CODE AS CODE,
		ITEM_NAME AS NAME,
		'DELETED' AS COMP_RSLT
	FROM
	(
		SELECT ITEM_CODE, ITEM_NAME
		FROM ITEM_HISTORY
		EXCEPT 
		SELECT ITEM_CODE, ITEM_NAME
		FROM ITEM
	)
	UNION
	-- 追加
	SELECT 
		ITEM_CODE AS CODE,
		ITEM_NAME AS NAME,
		'ADDED' AS COMP_RSLT
	FROM
	(
		SELECT ITEM_CODE, ITEM_NAME
		FROM ITEM
		EXCEPT 
		SELECT ITEM_CODE, ITEM_NAME
		FROM ITEM_HISTORY
	)
	UNION
	-- 更新
	SELECT 
		ITEM_CODE AS CODE,
		ITEM_NAME AS NAME,
		'UPDATED' AS COMP_RSLT
	FROM
	(
		SELECT I.ITEM_CODE, I.ITEM_NAME
		FROM 
			ITEM I
			INNER JOIN ITEM_HISTORY H
			ON I.ITEM_CODE = H.ITEM_CODE
		WHERE
			I.USER_UPDATE_DATETIME <> H.USER_UPDATE_DATETIME
	)
)
ORDER BY
	CODE DESC