SELECT 
	i.ITEM_CODE as CODE,
	NULLIF(i.ITEM_NAME,h.ITEM_NAME) as NAME
FROM
	ITEM as i
	LEFT OUTER JOIN ITEM_HISTORY as h 
	ON i.ITEM_CODE=h.ITEM_CODE

order by i.ITEM_CODE DESC;