Re: a LEFT JOIN problem - Mailing list pgsql-general

From Thomas
Subject Re: a LEFT JOIN problem
Date
Msg-id 55da14450810260210v17f46271ua31602eaae55c4d5@mail.gmail.com
Whole thread Raw
In response to Re: a LEFT JOIN problem  ("Tony Wasson" <ajwasson@gmail.com>)
Responses Re: a LEFT JOIN problem  (Thomas <iamkenzo@gmail.com>)
List pgsql-general
Hi Tony,

You nailed it! That's the piece of the puzzle I was missing. Moving
the filtering inside the ON clause was the solution.

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: How to tell PostgreSQL about a relationship
Next
From: Thomas
Date:
Subject: Re: How to tell PostgreSQL about a relationship