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

Using Query Builder

The following tasks provide the information you need to build SQL queries using Query Builder:

Defining a new query using Query Builder

Sizing the Conditions and Data Source panels

Displaying a query's SQL statements

Working with tables

Displaying information and comments on tables and columns

Renaming a table

Identifying a renamed table

Removing a table from a query

Accessing other accounts in the current database

Accessing other accounts in other databases

Working with conditions

Adding conditions to a query

Controlling join conditions in linked queries

Creating a negating condition

Creating a nested condition

Pasting a function

Working with columns

Creating a defined column

Deleting a defined column

Changing column order

Sorting query data

Changing the sort order

Deleting a sort column

Displaying information and comments on tables and columns

Working with relationships

Activating and deactivating a relationship

Creating a composite relationship

Creating a self-relationship

Creating a simple relationship

Creating an unmatched relationship

Removing unmatched rows

Deleting a relationship

See also

About Query Builder

About the Icon Bar

Data source object notation in the Query window

About Query Builder datatypes

Datatype icons

Condition syntax

About Query Builder operators

About Query Builder functions

About defined (and computed) columns

About Query Builder relationships

About unmatched (null) rows