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;