Contents Index Terminated by user -- transaction rolled back The column '%1' does not exist in the remote table

ASA Error Messages
  Database Error Messages
    Alphabetic list of error messages

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


Item Value
SQLCODE -862
Constant SQLE_INVALID_AGGREGATE_PLACEMENT
SQLSTATE 42W69
Sybase error code 13866
ODBC 2 State 37000
ODBC 3 State 42000
Parameter 1 The aggregated expression in error.
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.


Contents Index Terminated by user -- transaction rolled back The column '%1' does not exist in the remote table