3 way outer join dilemma

From: <terry(at)ashtonwoodshomes(dot)com>
To: "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: 3 way outer join dilemma
Date: 2003-08-18 23:50:51
Message-ID: 000c01c365e3$d0332460$2766f30a@development.greatgulfhomes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here's what I have (simplified)

SELECT t1.fid, t1.t1_data, t2.vid, t2.t2_data, t3.t3_data
FROM t1, t2, t3
WHERE t1.fid = X
AND t2.vid = Y
AND t3.fid = t1.fid
AND t3.vid = t2.vid

Now, I discover that the record in t3 may not always exist, so somehow I
want to do an outer join...

SELECT t1.fid, t1.t1_data, t2.vid, t2.t2_data, t3.t3_data
FROM t1, t2, OUTER JOIN t3 ON (t3.fid = t1.fid AND t3.vid = t2.vid)
WHERE t1.fid = X
AND t2.vid = Y

But I get the statement that "t1 is not part of JOIN"

Is there some way that I can merge t1 and t2 together, or do I have to do a
subselect (ugh) as the only viable alternative?

Any ideas is appreciated...

Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
terry(at)greatgulfhomes(dot)com
Fax: (416) 441-9085

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-08-19 00:18:55 Re: Why lower's not accept an AS declaration ?
Previous Message Dennis Gearon 2003-08-18 23:24:46 Re: Why lower's not accept an AS declaration ?