|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Trouble joining 3 tables
From: Brian Dunning (brian
briandunning.com)
Date: Mon Nov 02 2009 - 11:06:48 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]