Supported SQL Statements and Extensions for the Salesforce Driver
:
Select
:
From Clause
:
Subquery in a From Clause
Subquery in a From Clause
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
See also
Subqueries