Datasheet

Figure 8-14
You can see how we've now only got two columns and from two different tables. Let's see how
this works.
How It Works
The key to this is the wizard that allows you to build up an SQL statement. This is great if you are a
to SQL as you don't have to understand how the SQL language works. Perhaps the most important part
of this wizard is the
WHERE Clause Builder shown in Figure 8-11.
This is where (pun intended) we add the
WHERE part of the SQL statement, and this is what filters the
rows and joins tables together. We've selected the
Join option allowing us to specify the primary key
(
CategoryID in the Categories table) and the foreign key (CategoryID in the Products table).
The
WHERE clause becomes:
WHERE [Categories].[CategoryID] = [Products].[CategoryID]
270
Chapter 8
57076_Ch 8 SAN.qxd 01/12/2003 6:43 PM Page 270