Database Reference
In-Depth Information
Customer
table field list
52
Join line indicates
how these tables
are related
Rep table
field list
Fields from the
Rep table
Fields from the
Customer table
FIGURE 2-29
Query design to join two tables
Notice that the Table row in the design grid indicates the table with which each field is associated. The
query results appear in Figure 2-30.
Fields from the
Customer table
Fields from the
Rep table
FIGURE 2-30
Query results
EXAMPLE 14
For each customer whose credit limit is $10,000, list the customer's number and name, along with the num-
ber, last name, and first name of the corresponding sales rep.
