skip to main content
Supported SQL and Extensions : Salesforce, Marketing Cloud, Service Cloud, Dynamics, and Rollbase : Select : From Clause : Subquery in a From Clause
 

Try DataDirect Cloud Now
Subquery in a From Clause
Subqueries can be used in the From clause in place of table references (table_name). For example:
SELECT * FROM (SELECT * FROM emp WHERE sal > 10000) new_emp, dept WHERE new_emp.deptno = dept.deptno