Note: This example ... PROC SQL query retrieves data from the view descriptor; the subquery uses a Pass-Through query to retrieve data. This query returns the names of employees who earn less than the ...

Read this SQL tutorial to learn when to use ... doesn’t retrieve data from this column. Subqueries, or subselect statements, are a way to use a result set as a resource in another query to ...

To ensure that EFC can do that, you'll need to avoid doing anything in your SQL statement that would prevent it from being used in a subquery (for example: putting a semicolon at the end of your ...