Re: GROUP BY problem

[Colin McKinnon]

At 13:59 21/09/99 GMT, Steven Fletcher wrote:
>Hi all.
<snip>
>select count(chan.channel),nick.nick from chan, nick where
>(count(chan.channel) > "10" and chan.founder=nick.nick) group by
>nick.nick;
<snip>

Stuff in the where clause is evaluated before anyconsolidation is done -
i.e. count() is meaningless here; use a HAVING clause instead:

SELECT COUNT(chan.channel),nick.nick 
FROM chan, nick
WHERE chan.founder=nick.nick
GROUP BY nick.nick
HAVING count(chan.channel) > "10";

HTH
Colin