Database Reference
In-Depth Information
EXAMPLE 15
54
For each order, list the order number, order date, customer number, and customer name. In addition, for
each order line within the order, list the part number, description, number of units ordered, and quoted
price.
This query requires data from four tables: Orders (for basic order data), Customer (for the customer
number and name), OrderLine (for the part number, number ordered, and quoted price), and Part (for the
description). Figure 2-33 shows the query design.
Four tables
included
Join lines
FIGURE 2-33
Query to join multiple tables
The query results appear in Figure 2-34.
FIGURE 2-34
Query results
