Re: LEFT Join Question - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: LEFT Join Question
Date
Msg-id 20070126125835.GC18845@phlogiston.dyndns.org
Whole thread Raw
In response to LEFT Join Question  ("Rob V" <taketwosolutions@gmail.com>)
List pgsql-sql
On Thu, Jan 25, 2007 at 06:51:34PM -0500, Rob V wrote:
> 
> I know I have to use a left join - but I can seem to figure out the syntax
> when dealing w/ different columns of the same table.

I haven't tested this to remind myself for sure that it will work,
but I think you ought to be able to RIGHT OUTER JOIN the table you
just LEFT JOINed to to the next table using a different column.

A
-- 
Andrew Sullivan  | ajs@crankycanuck.ca
Information security isn't a technological problem.  It's an economics
problem.    --Bruce Schneier


pgsql-sql by date:

Previous
From: Luís Sousa
Date:
Subject: Evaluate a variable
Next
From: Alvaro Herrera
Date:
Subject: Re: Evaluate a variable