Hi, I'm trying to do a SELECT which then counts records in two separate tables, eg:
SELECT a_id, count(b_id) FROM a LEFT JOIN b USING(a_id) merged with SELECT a_id, count(c_id) FROM a LEFT JOIN c USING(a_id) So you would end up with a_id, count(b_id), count(c_id) Showing the number of records linked in each table respectively. Is there a simple way of doing this? For what it's worth, I'm using MySQL 3.23.49 and accessing it from PHP 4. Thanks, James --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php