Re: How Do You Do a Three Way Join?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: kvnsmnsn(at)cs(dot)byu(dot)edu, pgsql-novice(at)postgresql(dot)org
Subject: Re: How Do You Do a Three Way Join?
Date: 2007-05-22 16:05:50
Message-ID: 657052.22574.qm@web31809.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


--- kvnsmnsn(at)cs(dot)byu(dot)edu wrote:

> I've got three tables, <jqz>, <zqj>, and <abc>. I can do a
> <jqz j RIGHT JOIN zqj z> and a <zqj z LEFT JOIN abc a>, but is there a
> way to do a three-way join to get the columns of all three tables?

Take a look at "FULL OUTER JOIN".

http://www.postgresql.org/docs/8.2/interactive/queries-table-expressions.html#QUERIES-JOIN

Regards,
Richard Broersma Jr.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Stephan Szabo 2007-05-22 16:32:07 Re: How Do You Do a Three Way Join?
Previous Message kvnsmnsn 2007-05-22 15:51:25 How Do You Do a Three Way Join?