Guest_imported
New member
- Jan 1, 1970
- 0
I seem to be having problems executing a GROUP BY statement in an SQL code. An error message appears saying 'invalid use of group function'.
Here is my SQL code - any suggestions would be gratefully received...
SELECT subjectindex.subjectg, Count(subjectindex.indexl) AS CountOfindexl
FROM (useagelinks INNER JOIN subjectindex ON useagelinks.hit = subjectindex.indexl)
WHERE (((subjectindex.indexl)<>'ZZZ'))
GROUP BY subjectindex.subjectg
ORDER BY Count(subjectindex.indexl) DESC;
Here is my SQL code - any suggestions would be gratefully received...
SELECT subjectindex.subjectg, Count(subjectindex.indexl) AS CountOfindexl
FROM (useagelinks INNER JOIN subjectindex ON useagelinks.hit = subjectindex.indexl)
WHERE (((subjectindex.indexl)<>'ZZZ'))
GROUP BY subjectindex.subjectg
ORDER BY Count(subjectindex.indexl) DESC;