Re: Trouble joining 3 tables

Mon, 02 Nov 2009 09:07:19 -0800 

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
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to