Database Reference
In-Depth Information
80
Condition (customer
number must be 148)
Value is enclosed in
single quotation marks
because CustomerNum
is a character ield
FIGURE 3-9
SQL query to find the name of customer 148
The query results appear in Figure 3-10. Only a single record appears in the query results because the
CustomerNum field is the primary key for the Customer table and there can be only one customer with the
number 148.
Customer with
customer number 148
FIGURE 3-10
Query results
EXAMPLE 6
Find the customer name for every customer located in the city of Grove.
The query design appears in Figure 3-11.
Condition (city
must be Grove)
FIGURE 3-11
SQL query to find all customers located in Grove
