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.