Defining output columns
To define the output columns for an information object query, use the Columns page in Information Object Query Builder. For example, using Columns, you can create a SQL select statement that returns employee names from the Employees table and their annual compensation. The SQL fragment is as follows:
SELECT ename AS employee, (salary * 12) AS annual_comp
FROM Employees

Additional Links:

Copyright Actuate Corporation 2012