InterSystems IRIS TSQL Code 1015 An aggregate cannot appear in an ON clau

In this post, you’ll learn about the SQL error code 1015 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform

Error Code :

1015

Reason for the Error code 1015 in InterSystems IRIS DBMS

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.

Leave Your Comment