WITH Updated AS (
	select I.ITEM_Code, I.Item_Name, 'UPDATED' COMP_RSLT
	from ITEM I
	inner join ITEM_HISTORY IH
	on I.ITEM_CODE = IH.ITEM_CODE
	AND I.USER_UPDATE_DATETIME <> IH.USER_UPDATE_DATETIME
),
Added AS (
	select ITEM_CODE, ITEM_NAME, 'ADDED' COMP_RSLT
	from ITEM
	where ITEM_CODE IN (
		select ITEM_CODE FROM ITEm
		EXCEPT
		select ITEM_CODE FROM ITEM_HISTORY
	)
),
Deleted AS (
	select ITEM_CODE, ITEM_NAME, 'DELETED' COMP_RSLT
	from ITEM_HISTORY
	where ITEM_CODE IN (
		select ITEM_CODE FROM ITEM_HISTORY
		EXCEPT
		select ITEM_CODE FROM ITEm
	)
),
Result AS (
	select * FROM Added
	UNION 
	select * FROM Updated
	UNION 
	select * FROM Deleted
)
select 
 ITEM_CODE  CODE
,ITEM_NAME NAME
,COMP_RSLT
FROM REsult
order by 1 desc
;