Using column aliases in Actuate SQL

When you use column aliases, the following rules apply:

The column and alias names of the items in the first SELECT statement of a UNION of statements are definitive.

Within the items in a SELECT statement, you can use previously defined aliases to create expressions, for example:

SELECT col1 AS a, col2 AS b, a+b

Only SELECT and ORDER BY can use aliases.

You cannot use an alias in an aggregate expression, for example, MAX(a).

You can use aliases defined in an outer SELECT statement in a nested SELECT statement.

You can use aliases from the items in the first SELECT statement in a set of UNION statements in the ORDER BY clause of the query.

Copyright Actuate Corporation 2012