Selection page of the SQL designer
The Selection page in the SQL designer 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.
Selecting a field
Select a field from the Field drop-down list box. Fields will be available for each table that appears in the table pane. A Field may also be dragged from a table window in the table pane and dropped onto the Field column.
Specifying an output name
In the Output Name column for a field or summary, you may enter a name you wish to appear as the title for that field or summary data rather than using the default.
Producing summary data
Right-click in the grid and select Summary from the context menu. The grid will have three columns: Output Name, Summary, and Field. Select the appropriate function from the Summary column’s drop-down list box. You can also drag a field from a table window in the table pane and drop it onto the Field column.
When you add a summary, the SQL designer automatically groups on all of the non-summary fields to satisfy SQL syntax requirements.
Removing duplicate rows
When the Remove Duplicates box is checked every row in the query results will be unique. Checking this box adds the DISTINCT keyword to the SQL statement.
Deleting a row
After selecting the row to delete, right-click and choose Delete Row from the context menu.