You can also retrieve data from multiple DBMS tables in a single query by using the SQL procedure. This example joins the ORACLE tables STAFF and PAYROLL to query salary information for employees ...