You nailed it! That's the piece of the puzzle I was missing. Moving
the filtering inside the ON clause was the solution.
In response to
pgsql-general by date
|Next:||From: Thomas||Date: 2008-10-26 09:44:29|
|Subject: How to tell PostgreSQL about a relationship|
|Previous:||From: Tony Wasson||Date: 2008-10-26 03:51:41|
|Subject: Re: a LEFT JOIN problem|