--更新
select 
	 it.ITEM_CODE as CODE
	,it.ITEM_NAME as NAME
	,'UPDATED' as COMP_RSLT
from ITEM it 
	inner join ITEM_HISTORY ith
	 on it.ITEM_CODE = ith.ITEM_CODE
	and it.USER_UPDATE_DATETIME <> ith.USER_UPDATE_DATETIME
union
--登録
select 
	 it.ITEM_CODE as CODE
	,it.ITEM_NAME as NAME
	,'ADDED' as COMP_RSLT
from ITEM it 
	left join ITEM_HISTORY ith
	 on it.ITEM_CODE = ith.ITEM_CODE
where
	ith.ITEM_CODE is null
union
--削除
select 
	 ith.ITEM_CODE as CODE
	,ith.ITEM_NAME as NAME
	,'DELETED' as COMP_RSLT
from ITEM_HISTORY ith
	left join ITEM it
	 on it.ITEM_CODE = ith.ITEM_CODE
where
	it.ITEM_CODE is null
order by
	CODE desc