SELECT
	t0.ITEM_CODE AS CODE
	,CASE 
		WHEN t1.ITEM_NAME IS NULL THEN t0.ITEM_NAME
		WHEN t0.ITEM_NAME <> t1.ITEM_NAME THEN t0.ITEM_NAME
		ELSE NULL END AS NAME
FROM ITEM AS t0
LEFT OUTER JOIN ITEM_HISTORY AS t1
	ON t0.ITEM_CODE = t1.ITEM_CODE
ORDER BY t0.ITEM_CODE DESC