select ITEM.ITEM_CODE as CODE , nullif(ITEM.ITEM_NAME, ITEM_HISTORY.ITEM_NAME) as NAME
from ITEM left outer join ITEM_HISTORY on ITEM.ITEM_CODE = ITEM_HISTORY.ITEM_CODE
order by ITEM.ITEM_CODE desc;