From: Naz Gassiep (nazmira.net)
Date: Fri Sep 14 2007 - 19:25:42 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I am running this query:

SELECT group_post_mod_option.option_id,
       group_post_mod_option.option_name,
       COUNT(group_post_moderation.group_post_moderation_option) AS count
FROM group_post_mod_option
LEFT OUTER JOIN group_post_moderation ON
            (group_post_mod_option.option_id = group_post_moderation.group_post_moderation_option
             AND group_post_moderation.group_post_id = 37)
GROUP BY group_post_mod_option.option_id
ORDER BY COUNT(group_post_moderation.group_post_moderation_option),
         group_post_mod_option.option_name;
 
 
And getting this error:
'Invalid use of group function'

Without the "ORDER BY" clause, the query works just fine. Anyone know what's going on?

Regards,
- Naz.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]