Hi Edward; Thanks fot the reply.
I have a double error then ;-) First mistaken whats actually correct and then even trying to fix it ;-) Never mind. Best regards Nils Valentin Tokyo/Japan 2003年 7月 14日 月曜日 10:10、Becoming Digital さんは書きました: > Actually, "Live and Learn" is correct. "Life and Learn" makes no sense. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > Did I help you? Want to show your thanks? > www.amazon.com/o/registry/EGDXEBBWTYUU > > > > ----- Original Message ----- > From: "Nils Valentin" <[EMAIL PROTECTED]> > To: "Bruce Feist" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Friday, 11 July, 2003 22:16 > Subject: Re: Request modelling > > 2003年 7月 12日 土曜日 10:55、Nils Valentin さんは書きました: > > Hi Bruce; > > > > Thank you for the reply. > > > > I passed the core exam but obviously its not enough ;-) Live and learn > > ;-) > > Aeeh thats was supposed to be ... life and learn.. > Perhaps somebody knows a good spellchecker for logical mistakes ?? ;-) > That would have immediately popped up on my screen ;-) > > > Best regards > > Nils Valentin > Tokyo/Japan > > > Thank you very much for the reply. > > > > Best regards > > > > Nils Valentin > > > > 2003年 7月 12日 土曜日 10:20、Bruce Feist さんは書きました: > > > Nils Valentin wrote: > > > >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). > > > > > > That's precisely why HAVING exists. > > > > > > SELECT schedule_id,count(schedule_id) > > > FROM attendance > > > HAVING count(schedule_id) <10 > > > GROUP BY schedule_id ; > > > > > > Bruce Feist > > -- > --- > 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] -- --- 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]