Column references in the argument of a set function may not address view columns which are themselves derived from set functions.
The argument of a set function must contain at least one column reference and cannot contain any set function references. If the column is an outer reference, then the expression should not include any operators.
If a set function contains a column that is an outer reference, then the set function must be contained in a subselect of a HAVING clause.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40