Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: LEFT Join Question
- From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
- To: pgsql-sql(at)postgresql(dot)org
- Subject: Re: LEFT Join Question
- Date: Fri, 26 Jan 2007 07:58:35 -0500
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(at)crankycanuck(dot)ca Information security isn't a technological problem. It's an economics problem. --Bruce Schneier
- References:
- LEFT Join Question
- From: Rob V
- LEFT Join Question
- Prev by Date: Evaluate a variable
- Next by Date: Re: Evaluate a variable
- Previous by thread: Re: LEFT Join Question
- Next by thread: Intersection of two date interval
- Indexes: