Message-ID: <371ACCB0.6A437C5@TurnAround.com.au>
Date: Mon, 19 Apr 1999 16:26:56 +1000
From: Joe Shevland <J_Shevland@TurnAround.com.au>
Reply-To: J_Shevland@TurnAround.com.au
Organization: Turnaround Solutions Pty. Ltd.
MIME-Version: 1.0
To: Dan Janowski <danj@3skel.com>
CC: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] OUTER JOINS
References: <199904152011.QAA26538@fnur.3skel.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I didn't see a response for this, so here goes... I believe you can
implement joins using the followng syntax:

select t1.value from table_one t1, table_two t2 where t1.key = t2.key;

So this would be a straight LEFT join in my understanding. Now, I'm
venturing beyond my experience with PostgreSQL here, but you may be able
to use the associated SQL syntaxes:

select ... where t1.key *= t2.key
select ... where t1.key =* t2.key

etc...

I hope I'm right here :)

Regards,
Joe.

Dan Janowski wrote:
> 
> I've looked through the docs and mail lists but I am coming
> up short on references for LEFT/RIGHT/FULL OUTER JOIN
> avalability
> or functional workarounds. It seems that PostgreSQL does
> not have it.
> 
> Any recommendations on how to aproximate the functionality?
> 
> As a curiosity, is there a problem with supporting these
> OUTER joins or is it merely on the list?
> 
> Many thanks,
> 
> Dan
> 
> --
> Dan Janowski     danj@3skel.com       Triskelion Systems,
> Inc.     Bronx, NY

-- 
---------------------------------------------
 ,-._|\  | Joe Shevland
/      \ | Principal Consultant
\_,--._/ | Turnaround Solutions Pty. Ltd.
      v  | http://www.TurnAround.com.au
---------------------------------------------
Skate to where the puck is going and not to
where it has been - Wayne Gretzky