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

Defining a query using Query Builder

To define a query:

  1. In the Query window, click the Select Data Tables button in the Icon Bar to display the Select Data Tables dialog box.

  2. Double-click the table(s) from which you want to retrieve data (or select a table and click Include) to move it into the Query window. To include a range of tables, hold down the SHIFT key while clicking the first and last tables in the range.

  3. If you need to link a table to itself, select the table again.  

    Note:  If you include the same table more than once in a query, duplicate tables are automatically assigned system-generated alias names composed of the name for the base table, followed by an underscore and a number.

  4. When all the tables have been selected, click Close.

  5. Select each column (either select the check box next to the column, or double-click the column name).  To include all the columns, check the check box in the table title bar.  Note:  When you select a column object from a table, Query Builder automatically uses the table alias in your query.  Likewise, if you include a column object in the Condition field and accept the condition, Query Builder automatically inserts the appropriate table aliases into your condition.

  6. (Optional) Add one or more conditions to refine your query.

  7. (Optional) Create relationships.

  8. Click OK to generate the SELECT statement.

See also

Using Query Builder

Data source object notation in the Query window (Query Builder)

Displaying a query's SQL statements (Query Builder)

Sorting query data (Query Builder)

Displaying information and comments on tables and columns (Query Builder)

Controlling join conditions in linked queries (Query Builder)

Renaming a table (Query Builder)

Removing a table from a query (Query Builder)

Creating a defined column (Query Builder)

Deleting a defined column (Query Builder)

Changing column order (Query Builder)

Changing the sort order (Query Builder)

Deleting a sort column (Query Builder)

Creating an unmatched relationship (Query Builder)

Removing unmatched rows (Query Builder)

Activating and deactivating a relationship (Query Builder)

 

Creating a composite relationship (Query Builder)

 

Creating a self-relationship (Query Builder)

 

Creating a simple relationship (Query Builder)

 

Deleting a relationship (Query Builder)