SELECT List

The SELECT List Dialog box allows you to choose the fields on which you want to retrieve data. To open the dialog box, click on the Select button from the Visual Query Builder dialog box. All columns of the database, prefixed by their table names, will be displayed in the All Fields list box. To add a column to the Select list:

  1. Click on the column name on the Fields panel.
  2. On the Function panel, choose an aggregate function if you want to get a summary value for that column or choose None if not.
  3. On the Alias Name panel, enter an alias name if you want the name of the query column to be different from the database column name, or leave the alias field blank if not.
  4. Click on the Apply button to add the column to the list of query columns.
Repeat the above steps for each column you want to add to your query. To remove a column from the list of query columns, choose the column in the SELECT List panel, and click the Delete button. Note that deleting a column from the query columns will cause any previously configured Joins, Group By, Having, and Order By clauses to be reset. This is because these clauses are dependent on the columns in the select list. Also note that if your query contains aggregate columns and non-aggregate columns, then all non-aggregate columns must be included in the Group By clause. This is done automatically once you open the Group By dialog box. All you need is to set theirgroup key numbers.

Click on OK to update the changes, or Cancel to cancel any changes.