Re: Several left outer joins on a same table

В письме от 23 Июль 2002 15:38 Th Templ написал(а):
> 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
>
Look at NATURAL [FULL] OUTER JOIN

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