select
ITEM.ITEM_CODE as CODE,
CASE ITEM.ITEM_NAME
WHEN ITEM_HISTORY.ITEM_NAME THEN null
ELSE ITEM.ITEM_NAME
END as NAME
from
ITEM
left OUTER JOIN
ITEM_HISTORY
on
ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
order by CODE DESC