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: | Raw Message | Whole Thread | 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 ... |