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

The '%1' property is no longer supported Next Page

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


Item

Value

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.