ASA SQL Reference
SQL Language Elements
Expressions
A subquery is a SELECT statement that is nested inside another SELECT, INSERT, UPDATE, or DELETE statement, or another subquery.
The SELECT statement must be enclosed in parentheses, and must contain one and only one select list item. When used as an expression, a subquery is generally allowed to return only one value.
A subquery can be used anywhere that a column name can be used. For example, a subquery can be used in the select list of another SELECT statement.
For other uses of subqueries, see Subqueries in search conditions.