thankQ Help

After you have added the tables and selected the required columns, you can change settings for each column in the Grid pane

The following settings are available for each column.

•Use Column to select the required column from the combo box or add a new column

•The Table column displays corresponding table names

•The Alias column allows you to specify the column alias

Note that aggregated columns should always have an alias

•The Output column allows you to select whether to include specific columns to the query

•Use the Sorting type combo box to specify the sort order of column values. The Sort order column allows you to specify the order in which several columns are sorted

•The Group By statement is used in conjunction with the aggregate functions to group the result-set by one or more columns

•The Aggregate option allows you to specify the aggregate function used to aggregate column values