Quantified predicates and other subqueries
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
In OpenEdge SQL, subqueries are low-cost because they
are folded into the query tree as joins. The parser translates subqueries,
such as predicates preceded by ANY and ALL, to
an equivalent form that does not contain these keywords. Usually,
the new form is a join between the data in the subquery and the
data in the remainder of the SQL statement.