Hi John, Thank you for the reponse. I tried that (I didnt post it here), but that gives me the error
mysql> SELECT schedule_id,count(schedule_id) AS ct FROM attendance WHERE ct<10 GROUP BY schedule_id ; ERROR 1054: Unknown column 'ct' in 'where clause' Best regards Nils Valentin Tokyo/Japan 2003年 7月 12日 土曜日 10:03、John Coder さんは書きました: > 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 -- --- 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]