select 
	 ITEM.ITEM_CODE AS CODE
	,CASE WHEN  ITEM.ITEM_NAME <> ITEM_HISTORY.ITEM_NAME THEN ITEM.ITEM_NAME
		  WHEN  ITEM.ITEM_NAME <> ITEM_HISTORY.ITEM_NAME THEN NULL
	      WHEN  ITEM.ITEM_CODE is not null and ITEM_HISTORY.ITEM_CODE is null THEN ITEM.ITEM_NAME
	 END AS NAME
from  ITEM
left outer join ITEM_HISTORY
on    ITEM_HISTORY.ITEM_CODE = ITEM.ITEM_CODE
order by ITEM.ITEM_CODE desc