Re: How Do You Do a Three Way Join? - Mailing list pgsql-novice

From Richard Broersma Jr
Subject Re: How Do You Do a Three Way Join?
Date
Msg-id 657052.22574.qm@web31809.mail.mud.yahoo.com
Whole thread Raw
In response to How Do You Do a Three Way Join?  (kvnsmnsn@cs.byu.edu)
List pgsql-novice
--- kvnsmnsn@cs.byu.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.



pgsql-novice by date:

Previous
From: kvnsmnsn@cs.byu.edu
Date:
Subject: How Do You Do a Three Way Join?
Next
From: Stephan Szabo
Date:
Subject: Re: How Do You Do a Three Way Join?