Skip site navigation (1) Skip section navigation (2)

Re: a LEFT JOIN problem

From: Thomas <iamkenzo(at)gmail(dot)com>
To: "Tony Wasson" <ajwasson(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: a LEFT JOIN problem
Date: 2008-10-26 09:10:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.

In response to


pgsql-general by date

Next:From: ThomasDate: 2008-10-26 09:44:29
Subject: How to tell PostgreSQL about a relationship
Previous:From: Tony WassonDate: 2008-10-26 03:51:41
Subject: Re: a LEFT JOIN problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group