Subquery in a From clause
- Last Updated: November 2, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- Microsoft Sharepoint 6.0
- Documentation
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