Columns page

Use this page to specify the columns and expressions that you want to use in the SELECT statement.

You can either select the columns on this page or in the table graphics in the Tables pane.

Column
Select the column or specify the expression to include in the SELECT statement. To specify an expression, click Build Expression in the list, and then press Enter to open the Expression Builder wizard.
Alias
An optional field in which you can type an alias for the column or expression. When you run the statement, alias names are shown in the result set instead of the column name or expression.
Output
If this check box is selected, the column is included in the result set when the statement is run.
Sort Type
Select whether to sort the results for the corresponding column in ascending or descending order.
Sort Order
Select the order in which to sort the results.
Related tasks
Specifying SELECT statements in the SQL builder
Creating expressions in the Expression Builder wizard
Related reference
SQL builder for SELECT statements

Feedback