Invalid use of group function

cstevio · #1 (**permalink**) 10-18-05, 07:18

Hi,

I'm trying to run the following query:

mysql> SELECT
-> ad.id appid,
-> ad.name name,
-> count(rd.id) refs
-> FROM applicantDetails ad
-> LEFT OUTER JOIN referenceDetails rd ON (rd.applicantid = ad.id)
-> WHERE count(rd.id) < 2
-> GROUP BY ad.id, ad.name;

and I get this err message, it's quite annoying as I've managed to do this many times before in MSSQL.

ERROR 1111 (HY000): Invalid use of group function

Does anybody know what could be causing this, I'm using the latest version of MYSQL.

Thanks in advance

tombell · #2 (**permalink**) 10-18-05, 07:27

Code:

SELECT
 ad.id AS appid,
 ad.name AS name,
 count(rd.id) AS refs
FROM applicantDetails ad
 LEFT OUTER JOIN referenceDetails rd 
ON (rd.applicantid = ad.id)
 GROUP BY ad.id, ad.name
 HAVING count(rd.id) < 2

cstevio · #3 (**permalink**) 10-18-05, 07:40

Thanks!

That works a treat...

even works in M$SQL...

Internet Services

Web Development

Digital Marketing

Consumer Tech