September 2007
Intermediate to advanced
672 pages
13h 23m
English
In Chapter 5, Getting More Than Simple Columns, you learned a lot about using expressions to generate calculated columns to be output by your query. We didn’t tell you then that you can also use a special type of SELECT statement—a subquery—to fetch data from another table, even if the table isn’t in your FROM clause.
Let’s go back to the basics and take a look at a simple form of a SELECT statement in Figure 11-1.
This looks simple, but it really isn’t! In fact, the value expression part can be quite complex. Figure ...