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:
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.