Databases Reference
In-Depth Information
To indicate that either of two conditions must be true to select a record, place the first criterion in the
Criteria row for the first column and place the second criterion in the row labeled “or,” as shown in Figure 2-11.
39
Because the criteria
are on separate rows, only
one criterion needs to be
true to select a record
FIGURE 2-11
Query that uses an OR criterion
The query results appear in Figure 2-12.
Only those parts that
have more than 10 units on
hand or that are located in
warehouse 3 are included
FIGURE 2-12
Query results
EXAMPLE 6
List the number, name, and balance for each customer whose balance is between $1,000 and $5,000.
