SELECT --更新
	t1.ITEM_CODE AS CODE
	,t1.ITEM_NAME AS NAME
	,'UPDATED' AS COMP_RSLT
FROM ITEM AS t1
WHERE EXISTS(
	SELECT 1
	FROM ITEM_HISTORY AS t2
	WHERE t1.ITEM_CODE = t2.ITEM_CODE
		AND t1.USER_UPDATE_DATETIME <> t2.USER_UPDATE_DATETIME
		)
UNION

SELECT --追加
	t1.ITEM_CODE AS CODE
	,t1.ITEM_NAME AS NAME
	,'ADDED' AS COMP_RSLT
FROM ITEM AS t1
WHERE NOT EXISTS(
	SELECT 1
	FROM ITEM_HISTORY AS t2
	WHERE t1.ITEM_CODE = t2.ITEM_CODE
		)
UNION

SELECT --削除
	t2.ITEM_CODE AS CODE
	,t2.ITEM_NAME AS NAME
	,'DELETED' AS COMP_RSLT
FROM ITEM_HISTORY AS t2
WHERE NOT EXISTS(
	SELECT 1
	FROM ITEM AS t1
	WHERE t1.ITEM_CODE = t2.ITEM_CODE
		)
ORDER BY CODE DESC