subquery

Reference

Syntax

... ( SELECT ...
             FROM ...
             [WHERE sql_cond]
             [GROUP BY ...] [HAVING sql_cond] ) ... .

Effect

SELECT statement in parentheses that can be used in conditions sql_cond of OpenSQL statements for a subquery.

Additions

• As with statement SELECT. The SINGLE addition cannot be used.