On Fri, 2003-07-11 at 13:41, Nils Valentin wrote: > Hi MySQL Fans ;-) > > I would like to list all courses with have less than lets say 10 participants. > Does anybody know how I would have to modify the code below to get this to > work ? > > schedule_id is the course itself > > > SELECT schedule_id,count(schedule_id) FROM attendance WHERE > count(schedule_id)<10 GROUP BY schedule_id ; > > My problem is that I would need to use the count function actually within the > WHERE (clause which is not allowed).
Try SELECT schedule_id,count(schedule_id) as attendees FROM attendance WHERE antendees<10 GROUP BY schedule_id ; Johnn Coder -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
