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

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (T-Z)

 

The aggregate expression '%1' must appear in either the select list or a HAVING clause subquery

Error constant SQLE_INVALID_AGGREGATE_PLACEMENT
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 The aggregated expression in error.
Severity 15
SQLCODE –862
SQLSTATE 42W69
Sybase error code 13866
Probable cause

An aggregated expression containing an outer reference must either appear in a select list expression (a subselect), or in a HAVING clause subquery in the query whose FROM clause contains the table with the column being aggregated.