Database Reference
In-Depth Information
The only difference between this query and the one illustrated in Example 13 is that there is an extra
restriction
the credit limit must be $10,000. To include this new condition, add the CreditLimit field to
the design grid, enter 10000 as the criterion, and remove the check mark from the CreditLimit field
—
s Show
check box (because the CreditLimit column should not appear in the query results). The query design
appears in Figure 2-31.
'
53
Criterion (CreditLimit
must be 10000)
FIGURE 2-31
Query to restrict records in a join
Only customers with credit limits of $10,000 are included in the query results, as shown in Figure 2-32.
Only customers with
credit limits of $10,000
are included
FIGURE 2-32
Query results
Joining Multiple Tables
Joining three or more tables is similar to joining two tables. First, you add the field lists for all the tables
involved in the join to the upper pane, and then you add the fields to appear in the query results to the
design grid in the desired order.
