Database Reference
In-Depth Information
The query results appear in Figure 3-18.
84
Parts in warehouse 3
or with more than 20 units
on hand or both
FIGURE 3-18
Query results
EXAMPLE 10
List the descriptions of all parts that are not in warehouse 3.
For this example, you could use a simple condition and the
“
not equal to
”
operator (
). As an alterna-
<>
tive, you could use the
“
equals
”
operator (
) in the condition, but precede the entire condition with the NOT
¼
operator, as shown in Figure 3-19.
NOT operator indicates
that the condition must be false
for a record to appear in the
query results
FIGURE 3-19
SQL query with the NOT operator
