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 worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com