Re: Count records in join

essage- > >From: Miguel Vaz [mailto:pagong...@gmail.com] > >Sent: Wednesday, December 16, 2009 9:39 AM > >To: Johan De Meersman > >Cc: Gavin Towey; mysql@lists.mysql.com > >Subject: Re: Count records in join > > > >Thanks all for the feedback. Here's what i

RE: Count records in join

>-Original Message- >From: Miguel Vaz [mailto:pagong...@gmail.com] >Sent: Wednesday, December 16, 2009 9:39 AM >To: Johan De Meersman >Cc: Gavin Towey; mysql@lists.mysql.com >Subject: Re: Count records in join > >Thanks all for the feedback. Here's what i d

Re: Count records in join

e- >> From: Miguel Vaz [mailto:pagong...@gmail.com] >> Sent: Tuesday, December 15, 2009 10:43 AM >> To: mysql@lists.mysql.com >> Subject: Count records in join >> >> Hi, >> >> I am stuck with a suposedly simple query: >> >> - i have two tables (: &g

Re: Count records in join

se. > > Regards, > Gavin Towey > > -Original Message- > From: Miguel Vaz [mailto:pagong...@gmail.com] > Sent: Tuesday, December 15, 2009 10:43 AM > To: mysql@lists.mysql.com > Subject: Count records in join > > Hi, > > I am stuck with a suposedly simple qu

RE: Count records in join

l Vaz [mailto:pagong...@gmail.com] Sent: Tuesday, December 15, 2009 10:43 AM To: mysql@lists.mysql.com Subject: Count records in join Hi, I am stuck with a suposedly simple query: - i have two tables (: PROGS id_prog name EVENTS id id_prog name How can i list all records from PROGS with a sum o

Count records in join

Hi, I am stuck with a suposedly simple query: - i have two tables (: PROGS id_prog name EVENTS id id_prog name How can i list all records from PROGS with a sum of how many events each have? I want to find the progs that are empty. I remember something about using NULL, but i cant remember. :-