Database Reference
In-Depth Information
The query results appear in Figure 3-16.
83
Pa
rts in warehouse 3
with more than 20
units on hand
FIGURE 3-16
Query results
EXAMPLE 9
List the descriptions of all parts that are located in warehouse 3 or for which there are more than 20 units on
hand or both.
As you would expect, you form compound conditions with the OR operator similar to the way you use
the AND operator. The compound condition shown in Figure 3-17 uses the OR operator instead of the AND
operator.
Compound
condition
Because the condition
contains the OR operator,
either or both conditions must
be true for a record to appear
in the query results
FIGURE 3-17
Compound condition that uses the OR operator
