Use Queries to Filter Database Information

Expand All

Expand all collapsed sections.

Collapse All

Collapse all expanded sections.

Concept

Procedure

A query to the database is a search criterion that you construct to return the records you want.

Overview of Queries
Construct Simple Queries
The simplest query uses one operator to search one field for a certain value. The range query searches one field to return records that fall within a range you specify.
Use the Query Builder
Boolean operators and parenthetical grouping are used to create queries with two or more search criteria.
Use SQL Queries
If your database is fully compliant with the SQL 92 standard, you can use SQL statements to query more than one database table at a time.
Combine Queries
An advanced type of query uses operators on successive selection sets to return a new set of objects or records, which then can be further refined by the same process.
Save and Reuse Queries
When you save a query, you can later edit it, rename it, and copy it into other drawings.