select ITEM.ITEM_CODE as CODE, ITEM_HISTORY.ITEM_NAME as name
from ITEM left join ITEM_HISTORY on ITEM.ITEM_CODE == ITEM_HISTORY.ITEM_CODE
order by code desc;