Re: Left outer join question
От | Bill Reynolds |
---|---|
Тема | Re: Left outer join question |
Дата | |
Msg-id | 7C0800F63CCF4149AC0FC5EE2A041226053A1A00@sr002-2k3exc.ateb.com обсуждение исходный текст |
Ответ на | Re: Left outer join question (Raymond O'Donnell <rod@iol.ie>) |
Список | pgsql-general |
Thanks much. Silly Me, I had an extraneous comma -----Original Message----- From: Raymond O'Donnell [mailto:rod@iol.ie] Sent: Tuesday, October 07, 2008 8:12 PM To: Bill Reynolds Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Left outer join question 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@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
В списке pgsql-general по дате отправления: