Customize the column names
You can create aliases for column names to make it easier to work with
column names, calculations, and summary values. For example, you can create
a column alias to:
a column name, such as "Total" for an expression such as (quantity
* price) or for an aggregate function.
a shortened form of a column name, such as "d_id" for "discounts.stor_id."
After you have defined a column alias, you can use the alias in a Select
query to specify query output.
Creating a column alias
1. In the Grid pane, locate the row containing
the data column for which you want to create an alias, and if necessary,
mark it for output. If the data column is not already in the grid, add
2. In the Alias column for that row, enter the alias. The alias must
follow all naming conventions for SQL. If the alias name you enter contains
spaces, the program automatically puts delimiters around it.
How to create a view
About SQL Query Builder
SQL Query Builder Layout
Add or remove a table
Add a column
Customize the table
and view names
to retrieve certain records
Using wildcard characters
Show or hide
a column in a view's results
Group Rows in query results