Subquery in a From Clause
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Used in place of table references (table_name).
Syntax
SELECT * FROM (SELECT * FROM emp WHERE sal > 10000) new_emp, dept
WHERE new_emp.deptno = dept.deptno