| From: | kvnsmnsn(at)cs(dot)byu(dot)edu |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | How Do You Do a Three Way Join? |
| Date: | 2007-05-22 15:51:25 |
| Message-ID: | 53272.67.137.192.66.1179849085.squirrel@mail.cs.byu.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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? Of
course I could do one of those former two joins and then join the out-
put table to the third table, but is there a way to do it without cre-
ating the intermediate table?
I tried:
SELECT
j.abc, j.def, z.xyz, a.ghi
FROM
jqz j RIGHT JOIN zqj z LEFT JOIN abc a
ON
j.abc = z.abc AND z.xyz = a.xyz;
but <psql> complains about a syntax error "at or near" that last semi-
colon. Anybody know what I'm doing wrong, or what I can do to get my
desired three-way join? Or do I have to create that intermediate ta-
ble? Any information you can give me would be appreciated.
---Kevin
"You'll never get to heaven, or even to LA,
if you don't believe there's a way."
from _Why Not_
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2007-05-22 16:05:50 | Re: How Do You Do a Three Way Join? |
| Previous Message | Raimon Fernandez | 2007-05-22 10:17:27 | Re: oid or without oid ... |