Home > mailing lists

Full Outer Joins - Mailing list pgsql-novice

From	John Taylor
Subject	Full Outer Joins
Date	May 27, 2002 09:22:38
Msg-id	02052711145504.01493@splash.hq.jtresponse.co.uk Whole thread Raw
In response to	Re: optimising data load (John Taylor <postgres@jtresponse.co.uk>)
Responses	Re: Full Outer Joins ("Joel Burton" <joel@joelburton.com>)
List	pgsql-novice

Tree view

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

pgsql-novice by date:

From: Manfred Koizar
Date: 27 May 2002, 06:53:45
Subject: Re: Possible use of a subselect?

From: "Duncan Adams (DNS)"
Date: 27 May 2002, 10:59:54
Subject: find functions, triggers, views and rules.

Full Outer Joins - Mailing list pgsql-novice

Previous

Next