8.01 Define Subqueries
8.02 Describe the Types of Problems That the Subqueries Can Solve
8.03 List the Types of Subqueries
8.04 Write Single-Row and Multiple-Row Subqueries
Q&A Self Test
The previous six chapters have dealt with the SELECT statement in considerable detail, but in every case the SELECT statement has been a single, self-contained command. This chapter is the first of two that show how two or more SELECT commands can be combined into one statement. The first technique ...