Re: Trouble joining 3 tables

[Brian Dunning]

Thanks, this solved it!

On Nov 2, 2009, at 12:37 AM, Michael Dykman wrote:

> I suspect 'distinct' might help you out here.
>
> SELECT
>       people.*,
>       count(distinct cars.car_id) as car_count,
>       count(distinct pets.pet_id) as pet_count
>