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). I would appreciate any help or workaround. -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
