Re: Left outer join question

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
------------------------------------------------------------------