Progress
Results User’s Guide
for Windows


Query Basics

A query is a set of instructions that specifies the criteria by which information is extracted from a database. A query can retrieve data from one or more tables, from all the records in a table, or just a subset of records.

Once you have located the data you need, you can use a variety of sorting and filtering features to fine time and analyze the data. For example, to send catalogs to your current customers only, you might create a query to locate the names and addresses of all your customers who ordered merchandise in the last year. Then you can use the query to generate mailing labels, create printed reports, update the information stored in the database, and even create a data file to export the data to another application.

This chapter explains the basics of creating and using queries as follows:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095