Sybase Error – The aggregate expression ‘%1’ must appear in either the SELECT list or a HAVING clause subquery

In this blog post, you’ll learn more about the Sybase Error The aggregate expression ‘%1’ must appear in either the SELECT list or a HAVING clause subquery and the reason for receiving this error

Sybase SQL Error Message

The aggregate expression ‘%1’ must appear in either the SELECT list or a HAVING clause subquery

Reason for this Error

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.