Full Outer Joins

From: John Taylor <postgres(at)jtresponse(dot)co(dot)uk>
To: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Full Outer Joins
Date: 2002-05-27 10:14:55
Message-ID: 02052711145504.01493@splash.hq.jtresponse.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi,

Can someone give me examples for the correct syntax for FULL OUTER JOIN, where each table
has some additional conditions. The docs don't give any complete examples :-(

I can only get it to work using subselects:

SELECT stock,o.ordercurrent,s.quantity FROM
(SELECT stock,ordercurrent FROM orderlines o WHERE o.theorder=' 4494' AND (o.type='P' OR o.type='T')) AS o
FULL OUTER JOIN
(SELECT stock,quantity FROM standingorders s WHERE s.account=' 15048' AND s.dayno=2) AS s
USING (stock)

Thanks
JohnT

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Duncan Adams (DNS) 2002-05-27 11:58:42 find functions, triggers, views and rules.
Previous Message Manfred Koizar 2002-05-27 07:53:41 Re: Possible use of a subselect?