To add a field to the list of query output fields, do as follows:
In the Query Building Canvas, check the box at the
left of the field name in the datasource field list, or
In Apply Operations, go to the
Expression column and select a field name
from the drop-down list.
To include all the fields of the object, check the box at the left of the
asterisk item in the datasource field list.
Note:
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, for example, Select * From "…". This is
because a SELECT query without any columns will produce an error for
most database servers.
If you select any field or add any output expression to the query,
the asterisk item is removed from the query.
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.
To set an aggregate function, select an aggregate from the drop-down list in
the Aggregate column. An aggregate function runs the
calculation on a set of values and returns a single value.