SELECT
 I.ITEM_CODE AS CODE,
 NULLIF(I.ITEM_NAME, IH.ITEM_NAME) AS NAME
 
FROM
 ITEM AS I
  LEFT OUTER JOIN ITEM_HISTORY AS IH
  ON I.ITEM_CODE = IH.ITEM_CODE
  
ORDER BY
 I.ITEM_CODE DESC;