Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 22 May 2007 09:05:50 -0700 (PDT)
--- 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.
- References:
- How Do You Do a Three Way Join?
- From: kvnsmnsn
- How Do You Do a Three Way Join?
- Prev by Date: How Do You Do a Three Way Join?
- Next by Date: Re: How Do You Do a Three Way Join?
- Previous by thread: How Do You Do a Three Way Join?
- Next by thread: Re: How Do You Do a Three Way Join?
- Indexes: