Inventory Check Join

SELECT R.RSO_NAME, R.RSO_ADVISOR, I.ITEM_NAME, I.TAG_NUM FROM RSO R, INVENTORY I WHERE I.RSO_NAME = R.RSO_NAME;