FULL JOIN with 3 or more tables

From: Michael Adler <adler(at)glimpser(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: FULL JOIN with 3 or more tables
Date: 2002-04-03 20:58:55
Message-ID: Pine.NEB.4.44.0204031533070.13855-100000@reva.sixgirls.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php pgsql-sql


I can do full joins just fine on two tables at a time:

FROM t1 FULL JOIN t2 ON (t1.id = t2.id)

Now, how would I full joint in a third table?

FROM t1 FULL JOIN t2 ON (t1.id = t2.id) FULL JOIN t3 ON t1.id = t3.id

That previous line would not join together two rows from t2 and t3.

Thanks,

Mike

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message eyou321 2002-04-04 06:03:06 ADV: Harvest lots of Email addresses quickly
Previous Message Joe Conway 2002-04-03 16:12:45 Re: bytea or large object

Browse pgsql-sql by date

  From Date Subject
Next Message Ewald Geschwinde 2002-04-03 21:14:24 Re: date manipulation
Previous Message Travis Hoyt 2002-04-03 20:15:02 date manipulation