Databases Reference
In-Depth Information
35
Asterisk in the
Orders table
field list
Asterisk indicates
that all fields will
be included in the
query results
FIGURE 2-5
Query that includes all fields from the Orders table
The query results appear in Figure 2-6.
All fields from
the Orders table
are included
FIGURE 2-6
Query results
When the records that you want to display in a query's results must satisfy a condition, you enter the condition
in the appropriate column in the design grid. Conditions that data must satisfy are also called
criteria
.(A
single condition is called a
criterion
.) The following example illustrates the use of a criterion to select data.
EXAMPLE 3
Find the name of customer 148.