RE: COUNT and WHERE

if you use an alias in your select clause use the same alias in the having clause so having num > 1 -Original Message- From: Ben Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 11:00 AM To: [EMAIL PROTECTED] Subject: COUNT and WHERE Hello, I have this query sel

COUNT and WHERE

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