Selecting Output Fields

To add a field to the list of query output fields, check the box at the left of the field name in the datasource field list in the Query Building area. To include all the fields of the object, check the box at the left of the asterisk item in the datasource field list. You may also drag fields from the Query Building area to the Columns pane to get the same result.

If you do not select any fields from the query datasources, an asterisk item will be added to the select list of the resulting query ("Select * From ..."). This is because a SELECT query without any columns will produce an error for most database servers. The asterisk item is removed from the query if you select any field or add any output expression to the query.

Tip: Another way to add a field is to select a field name from the drop-down list of the Expression column in the Columns pane. You may also type any valid expression in the Expression column in the Columns pane. To insert an empty line to the Columns pane, press the Alt+Insert key.

To remove a field from the Columns pane, clear the check box at the left of the field name in the Query Building area or press the Alt+Delete key in the Columns pane.

To move a line up press the Alt+Up key. To move a line down press the Alt+Down key.

To remove an expression from the SELECT list of the query, clear the check box in the Output column.

To set an alias for an expression, enter the alias in the Alias column. Aliases become the headings of columns in the resulting dataset.