Re: Several left outer joins on a same table - Mailing list pgsql-jdbc

Templ,

What exactly is your question here? You can easily test your sql out in
psql. AFAIK, postgres should handle two outer joins. If you have access
to the source for the driver have a look at the getImportedExported keys
to see very complex sql selects that do multiple joins on the same
tables

Dave
On Tue, 2002-07-23 at 05:38, Th Templ wrote:
> Hello,
>
> This is a problem about several left outer joins on a same table.
>
> Here are my tables
>
> Personne
> ------------
> int lieu1
> int lieu2
>
> Lieu
> ------------
> int lieu_id
> varchar(50) lieu_nom
>
> I want to have in a single request the name of lieu1 and/or lieu2 in the
> 'Lieu' table if there is a correspondance and if there are not null.
> I see the postgresql documentation and I have no problem to make one left
> outer join, but two??
>
> Thans for your answers
> Templ
>
> _________________________________________________________________
> Join the world’s largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>