| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Bill Reynolds <Bill(dot)Reynolds(at)ateb(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Left outer join question |
| Date: | 2008-10-08 00:12:26 |
| Message-ID: | 48EBFAEA.7010304@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 08/10/2008 01:02, Bill Reynolds wrote:
> Is it possible to have a left outer join on 2 tables from the same
> originating table where T1 left outer joins to T2 and T1 left outer
> joins to T3? I guess I'm stuck on the FROM clause syntax or trying to
> do something you just can't do.
Maybe I'm missing something, but it ought to be just:
...from T1
left join T2 on (T1.a_column = T2.a_column)
left join T3 on (T1.another_column = T3.another_column)
etc.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Reynolds | 2008-10-08 00:36:18 | Re: Left outer join question |
| Previous Message | Bill Reynolds | 2008-10-08 00:02:19 | Left outer join question |