A script-enabled browser is required for this page to function properly.

About Query Builder

Query Builder is an easy-to-use data access tool designed for analysts, managers, and other business professionals. It provides a logical and intuitive means to access information from your organization's databases for analysis and reporting.

Query Builder is designed for professionals who do not have a computer programming or database background. Because of its powerful query features and its support of Structured Query Language (SQL) statements, experienced database users and programmers will find that Query Builder serves many of their needs as well.

In Query Builder's graphical Query window , you can specify a request for data from your organization's database(s). The request for data is called a query.

You can use Query Builder to define almost any query that you would build using a SQL SELECT statement. Query Builder automatically generates the appropriate SELECT FROM [table.column] clause based on columns displayed in the Query Builder workspace.

See also

Using Query Builder

Defining a new query using Query Builder

About Query Builder datatypes

About Query Builder functions

About Query Builder operators

About Query Builder relationships

About conditions (Query Builder)

About defined (and computed) columns (Query Builder)

About unmatched (null) rows (Query Builder)