SELECT
ITEM.ITEM_CODE as CODE,
CASE
WHEN ITEM.ITEM_NAME != his.ITEM_NAME then ITEM.ITEM_NAME else null end as NAME
FROM ITEM
left join ITEM_HISTORY as his
ON ITEM.ITEM_CODE = his.ITEM_CODE
order by CODE