On Tue, Jun 16, 2009 at 2:52 PM, Hall, Crystal M CTR DISA JITC<crystal.hall....@disa.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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
