I wish to get a count of records contained in 1 table as compared to the contents of a different table. What I have is a list of realtors in 1 table (agents.name) The listings are contained in a different table (listings) and each can be identified by their agent by listings.agent.
Here's the query I've tried using alias and COUNT but it doesn't seem to work. In fact it's telling me that the table (listings) doesn't even exist when I know it does. SELECT name, COUNT(*) as cnt from agents where agents.name = listings.agent; What I need to accomplish is to generate a report where it will list out each agent in agents followed by the number of listings posted by them in listings even if it is zero. TIA, Ed --------------------------------------------------------------------- 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
