select
  ITM.ITEM_CODE as CODE
  ,CASE
    WHEN HIS.ITEM_NAME IS NULL          THEN ITM.ITEM_NAME
    WHEN ITM.ITEM_NAME = HIS.ITEM_NAME  THEN NULL
    WHEN ITM.ITEM_NAME != HIS.ITEM_NAME THEN ITM.ITEM_NAME
    ELSE NULL
  END as NAME
from
  ITEM ITM
  LEFT OUTER JOIN
    ITEM_HISTORY HIS
    ON
      ITM.ITEM_CODE = HIS.ITEM_CODE
order by
  ITM.ITEM_CODE DESC
;