Re: left outer join on more than 2 tables? (UNCLASSIFIED)

On Tue, Jun 16, 2009 at 2:52 PM, Hall, Crystal M CTR DISA
JITC<Crystal(dot)Hall(dot)ctr(at)disa(dot)mil> wrote:

> Maybe I am way of base here, but I see a reference to region in this
> query.  However, I think count(cm.id) is correct because some would have
> a count of 0.  Count(*) would produce counts when there are no
> complaints. (If I understand the logic, again, I am VERY new to this)

Here is a very good website to visit to get practice with SQL using PostgreSQL.

http://www.sqlzoo.net/select_group_by

If you look up at the upper right corner of the web-page, you can
select PostgreSQL are your RDBMS (other flavors are available also).

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug