Error 861

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

Item Description

SQLCode

-861L

Constant

MULTIPLE_AGGREGATE_COLUMNS

SQLState

42W68

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2510

Severity Code

15

Parameter 1

The aggregated expression in error.

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.


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com