| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | <terry(at)ashtonwoodshomes(dot)com> |
| Cc: | "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 3 way outer join dilemma |
| Date: | 2003-08-19 00:21:33 |
| Message-ID: | 20030818171914.Y41521-100000@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 18 Aug 2003 terry(at)ashtonwoodshomes(dot)com wrote:
> 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
Maybe:
FROM t1 CROSS JOIN t2 LEFT OUTER JOIN t3 ON ...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-08-19 00:44:58 | Re: Why lower's not accept an AS declaration ? |
| Previous Message | Stephan Szabo | 2003-08-19 00:18:55 | Re: Why lower's not accept an AS declaration ? |