Progress
Language Tutorial
for Windows
Summary
This chapter explained how to select, sort, and relate records from different tables.
Selection Options
These options allow you to specify which records to retrieve:
Sorting Options
These options allow you to specify how to sort the records:
Relating Records
Database tables have a relationship if they have a field with identical data in common. There are two kinds of relationships between tables:
The field with identical data that is held in common between two tables is called the key.
Three options allow you to establish relationships between database tables:
- The EACH phrase allows you to relate multiple tables.
- The OF option allows you to relate tables in a search by specifying the key field. The key must be an indexed field in at least one of the tables.
- The WHERE option relates tables in which the key is not an indexed field, or the key field doesn’t have the same name in both tables.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |