List:General Discussion« Previous MessageNext Message »
From:Bjoern Frantzen Date:April 4 1999 11:15am
Subject:Re: Re: count(*) involving several tables?
View as plain text  
 Quoting Benjamin Scherrey (scherrey@stripped):
> select name, count( table1_id ) from table1 left join table2 on table2.table1_id
> = table1.id group by name;
> Should give you the results you're looking for.

That did speed things up by a factor of 20 or so, yes. Thanks a lot!

-- 
             Bjørn Frantzen

     
Thread
count(*) involving several tables?Bjoern Frantzen3 Apr
  • Re: count(*) involving several tables?Benjamin Scherrey4 Apr
    • Re: Re: count(*) involving several tables?Bjoern Frantzen4 Apr