Re: [GENERAL] Left outer join question

2008-10-07 Thread Bill Reynolds
Thanks much. Silly Me, I had an extraneous comma -Original Message- From: Raymond O'Donnell [mailto:[EMAIL PROTECTED] 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,

Re: [GENERAL] Left outer join question

2008-10-07 Thread Raymond O'Donnell
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

[GENERAL] Left outer join question

2008-10-07 Thread Bill Reynolds
Hey folks, stuck on something here and maybe I went down a dead end road. 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 yo