SQL Server Error Msg 1015 – An aggregate cannot appear in an ON clause unless it is in a subquery contained in a HAVING clause or select list, and the column being aggregated is an outer reference.

In this blog post, let’s learn about the error message “1015 – An aggregate cannot appear in an ON clause unless it is in a subquery contained in a HAVING clause or select list, and the column being aggregated is an outer reference.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

1015 – An aggregate cannot appear in an ON clause unless it is in a subquery contained in a HAVING clause or select list, and the column being aggregated is an outer reference.

Reason for the Error

To be update soon…

Solution

To be update soon…