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

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