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