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/[EMAIL PROTECTED]