How to Specify Output Columns
Output columns are those columns that appear in the Select list of your SQL statement, which are displayed both on the SQL tab and on the Results tab of the Select List pane.
If you do not add any output columns, the SQL Definer will assume:
To specify output columns:
You can also select multiple columns from the column list using the SHIFT/CTRL keys. If you require all the columns of a table, select the pseudo column (*).
When using GROUP BY, first specify which columns are in the GROUP BY clause by dragging them onto the Group By Definitions tab in the Select List. Then specify any required group functions on these columns by editing the output column names on the Column Definitions tab.
If you wish to set/change the order of output columns, select the Column Definitions tab in the Select List and type numbers (in descending order of position) in the Position field.