SQL designer elements

Topic group

The SQL designer is comprised of two main sections:

1. The table pane, the upper portion of the designer, where tables and fields are depicted. This area lets you select and deselect data for your queries. You can also use these table listings to quickly create joins.

• The query notebook is the tabbed lower portion of the designer. Each page of the notebook offers a grid layout for specifying query parameters and options.

The notebook pages are:

Criteria. Where you specify which rows of data are to be included in the query results.

Selection. This page enables you to create summary data. It also allows you to specify a customized output name for a field or summary data in the query results.

Grouping. Use this page to create a grouped query. A grouped query groups the data from the source tables and produces a single summary row for each row group.

Group Criteria. Enables you to specify group selection criteria used in the HAVING clause that SQL designer adds to the query. A HAVING clause selects and rejects row groups.

Sorting. Where you specify a sort order for the query.

Joins. This page lets you create multi-table SQL queries (joins).