iAnywhere.com - Aggregated expression '%1' contains multiple columns of which one or more are outer references

Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Aggregated expression '%1' contains multiple columns of which one or more are outer references

Item	Value
Constant	SQLE_MULTIPLE_AGGREGATE_COLUMNS
ODBC 2 State	37000
ODBC 3 State	42000
Parameter 1	The aggregated expression in error.
Severity	15
SQLCODE	-861
SQLSTATE	42W68
Sybase error code	13865

Probable cause

A subselect within the nested query contains an aggregate function whose parameters include an outer reference. In such cases, the outer reference must be the only column referenced in the expression.