count from 3 tables
- Date: Tue, 13 May 2008 15:08:49 +0700
- From: sangprabv <sangprabv@xxxxxxxxx>
- Subject: count from 3 tables
Hi,
I have 3 tables which I want to count records from. The tables are
users, phonebooks, groups. I want to count how many phonebooks and
groups does a user have. Currently I try to use this query:
SELECT users.username, count( phonebooks.key_user ) AS pb,
count( groups.key_user ) AS gp
FROM users
LEFT JOIN (
phonebooks, groups
) ON ( phonebooks.key_user = users.key_user
AND groups.key_user = users.key_user )
GROUP BY users.username
But the result was wrong. Does anybody know why it's wrong and how to
solve it?
TIA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx