Re: How Do You Do a Three Way Join?

--- 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.