SQL Statements and Extensions for the Salesforce Driver : Select : Select Clause : From Clause : Subquery in a From Clause

Subquery in a From Clause
Subqueries can be used in the From clause in place of table references (table_name).
Example
SELECT * FROM (SELECT * FROM emp WHERE sal > 10000) new_emp, dept WHERE new_emp.deptno = dept.deptno
See also
For more information about subqueries, see Subqueries.

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.