Re: left outer join on more than 2 tables?

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: left outer join on more than 2 tables?
Date: 2009-06-16 22:50:21
Message-ID: 396486430906161550v30befebelcfddd58ebc4b4f2d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jun 16, 2009 at 2:40 PM, Rob Sargent<robjsargent(at)gmail(dot)com> wrote:

> Is there a city without a reference to region?

I don't know, but the OP wanted to know complaints by region.

>  And wouldn't you want to count(cm.id)?

Count(cm.id) and Count(*) produce the same result. But I like
Count(*) more since it helps to correctly express the idea that we are
counting rows per group and not cm.id(s) per group.

--
Regards,
Richard Broersma Jr.

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Broersma 2009-06-16 22:54:16 Re: left outer join on more than 2 tables? (UNCLASSIFIED)
Previous Message Richard Broersma 2009-06-16 22:45:03 Re: left outer join on more than 2 tables?