Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Using Subqueries

Nested subqueries Next Page

How subqueries work

Understanding which queries are valid and which ones aren't can be complicated when a query contains a subquery. Similarly, figuring out what a multi-level query does can also be very involved, and it helps to understand how SQL Anywhere processes subqueries. For general information about processing queries, see Summarizing, Grouping, and Sorting Query Results.

Correlated subqueries
Converting subqueries in the WHERE clause to joins
Comparison operators
Quantified comparison test
Set membership test
Existence test