
Note
When working with a query, more than one table can be used.
Since different tables may contain the same field names, the
format for naming fields in a query is Table name.field name,
with a period (.) between the table name and the field name. For
example, The Lunch field of the Vacation table used in a query
has the name Vacation.Lunch.
Step 1: Select the fields.
1) Select the CD-Collection table from the dropdown list of tables.
2) Select fields from the CD-Collection table in the Available fields
list.
a) Click Artist, and use the > button to move it to the Fields in
the Query list.
b) Move the AlbumTitle and DatePurchased fields in the same
manner.
c) Click Next.
Tip
To change the order of the fields, select the field you want to
move and click the up or down arrow.
Figure 226: First page of the Query Wizard
294 Getting Started with OpenOffice.org 3.x
Kommentare zu diesen Handbüchern