Hello,
I have this query
select a.match_id, count(a.players_id) as num, a.description
from a
group by a.players_id, a.match_id
order by num desc
I only want to see the records where the count of players_id is greater than
1, and in various other DB's i'd use the Having clause, so i tried
where count(a.players_id)>1
but mySQL said Invalid use of Group By function, which i guess is
understandable.
I'm sure there is an easy solution, anyone with any suggestions ?
thanks in advance.
Ben.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php