CODEWITHSUNDEEP
sqlselectsummysql-error-1111
user2076306
user2076306

Reputation: 21

#1111 - Invalid use of group function error in sql

Does anyone know a solution for this error: #1111 - Invalid use of group function

This is my SQL:

SELECT leerlingen.leerlingnummer, voornaam, tussenvoegsel, achternaam, klas, leerlingen.bestemming 
FROM betalingen, leerlingen, bestemmingen
WHERE leerlingen.leerlingnummer = betalingen.leerlingnummer AND SUM( betalingen.bedrag ) > bestemmingen.bedrag
GROUP BY leerlingen.leerlingnummer

Upvotes: 1

Views: 2149

Answers (1)

Brandon Moretz
Brandon Moretz

Reputation: 7631

You can't reference the results of an aggregate function (SUM) in predicated query (WHERE), you will have to specify the aggregate in the select, then use a "Having" clause to filter that set.

Upvotes: 4

Related Questions