WITH D1 AS (
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	ITEM_HISTORY
EXCEPT
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	ITEM
),
U1 AS (
SELECT
	ITEM_CODE
,	ITEM_NAME
,	USER_UPDATE_DATETIME
FROM
	ITEM_HISTORY
EXCEPT
SELECT
	ITEM_CODE
,	ITEM_NAME
,	USER_UPDATE_DATETIME
FROM
	ITEM
),
A1 AS (
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	ITEM
EXCEPT
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	ITEM_HISTORY
),
U2 AS (
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	U1
EXCEPT
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	D1
),
U3 AS (
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	U2
EXCEPT
SELECT
	ITEM_CODE
,	ITEM_NAME
FROM
	A1
)
SELECT
	ITEM_CODE AS CODE
,	ITEM_NAME AS NAME
,	'ADDED' AS COMP_RSLT
FROM
	A1
UNION
SELECT
	ITEM_CODE AS CODE
,	ITEM_NAME AS NAME
,	'UPDATED' AS COMP_RSLT
FROM
	U3
UNION
SELECT
	ITEM_CODE AS CODE
,	ITEM_NAME AS NAME
,	'DELETED' AS COMP_RSLT
FROM
	D1
ORDER BY
	CODE DESC