SELECT
I.ITEM_CODE AS CODE,
I.ITEM_NAME AS NAME,
CASE
WHEN I.ITEM_CODE IS NULL THEN 'DELETED'
WHEN IH.ITEM_CODE IS NULL THEN 'ADDED'
WHEN I.USER_UPDATE_DATETIME <> IH.USER_UPDATE_DATETIME THEN 'UPDATED'
END AS COMP_RSLT
FROM
ITEM I
LEFT OUTER JOIN ITEM_HISTORY IH ON I.ITEM_CODE = IH.ITEM_CODE
WHERE
I.ITEM_CODE IS NULL
OR IH.ITEM_CODE IS NULL
OR I.USER_UPDATE_DATETIME <> IH.USER_UPDATE_DATETIME
ORDER BY
CODE DESC;