Databases Reference
In-Depth Information
EXAMPLE 15
52
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 num-
ber 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
