SELECT
I.ITEM_CODE as CODE
,CASE I.ITEM_NAME WHEN H.ITEM_NAME_H THEN Null 
  ELSE I.ITEM_NAME END as NAME
FROM
ITEM I
LEFT JOIN
(SELECT
ITEM_CODE as ITEM_CODE_H
,ITEM_NAME as ITEM_NAME_H
FROM ITEM_HISTORY) H
ON 
I.ITEM_CODE=H.ITEM_CODE_H
ORDER BY CODE DESC