Quantified predicates and other subqueries
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- 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.