select a.ITEM_CODE as CODE, a.ITEM_NAME as NAME
from ITEM a LEFT OUTER JOIN ITEM_HISTORY p on a.ITEM_CODE = p.ITEM_CODE
order by a.ITEM_CODE desc;