Datasheet

If we wanted to add a third table, perhaps Suppliers, we could use an AND clause. Once you've declared
one
WHERE clause, the WHERE button has a different name – AND Clause as shown in Figure 8-15:
Figure 8-15
Pressing the
AND Clause button shows the same WHERE Clause Builder, but this time you'd set the link
between the
Suppliers and Products tables as shown in Figure 8-16:
Figure 8-16
271
Reading From Databases
57076_Ch 8 SAN.qxd 01/12/2003 6:43 PM Page 271