Contents Index Combining WHERE and HAVING clauses Introducing subqueries

ASA Getting Started

Selecting Data Using Subqueries


About this chapter 

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.


Introducing subqueries
Introduction
Single-row and multiple-row subqueries
Using subqueries instead of joins

Contents Index Combining WHERE and HAVING clauses Introducing subqueries