==
"Patriotism is the willingness to kill and
be killed for trivial reasons."
- Bertran Russell
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 20, 2002 2:14 PM
To: [EMAIL PROTECTED]
Subject: Count and Selects
I
I'm trying to get a count of records by combining a search from 2 seperate
tables.
I have both listings and agents as tables. What I need to do is get a
agent, ad count for all the agents listed in agents even if they don't
have any ads in listings.
Here's the query:
select name, count(*) as cn