Datasheet

Figure 8-9
Now you can select the columns you wish to show. You can pick multiple columns (the
* column means
all columns from the table) from multiple tables. You simply select them individually. However, when
picking columns from multiple tables, you must join the tables. Remember our discussion of linked
tables and keys from the beginning of the chapter – you need the primary and foreign key to join the
tables.
5. Select the Products table and the ProductName column, and the Categories table and the
CategoryName column. Notice the Preview pane at the bottom of the window shows the SQL
statement, but without the tables joined together, as shown in Figure 8-10:
Figure 8-10
6. To join these tables together, we need a WHERE clause, so press the WHERE button to open the
WHERE Clause Builder window.
267
Reading From Databases
57076_Ch 8 SAN.qxd 01/12/2003 6:43 PM Page 267