Use SQL to quickly ... create a new table containing a subset of records from a larger table. For example, suppose in Access you want to create a phone list for all employees in the Fort Myers ...

When a PROC SQL query contains subqueries or inline views, the innermost query is evaluated first. In this example, data is retrieved from the SYBASE EMPLOYEES table and returned to the subquery for ...