First Guide to SQL Anywhere Studio
PART 3. Basic SQL
This chapter shows how to use the results of one query as part of another SELECT statement. This is a useful tool in building more complex and informative queries.
Preparing to use subqueries
A simple subquery
Comparisons using subqueries
Using subqueries instead of joins