Posted by Ewoud Dronkert on 05/25/05 14:54

On Wed, 25 May 2005 12:52:08 +0100, StealthBananaT wrote:
>>> My database has two tables - films has 10,000 records and reviews has 20,000 records.
>>> SELECT films.*, COUNT(reviews.id)
>
> The code definitely works - I've tried it with fewer records.

Try restricting the number of fields you select from films to just the
title, for example.


--
Firefox Web Browser - Rediscover the web - http://getffox.com/
Thunderbird E-mail and Newsgroups - http://gettbird.com/

[Back to original message]