From: Bjoern Frantzen
Date: April 4 1999 11:15am
Subject: Re: Re: count(*) involving several tables?
List-Archive: http://lists.mysql.com/mysql/1402
Message-Id: <19990404131559.A8840@bgnett.no>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

 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