Re: Re: count(*) involving several tables?

[Bjoern Frantzen]

 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