Re: Left outer join and sub queries alias

On Thursday 23 October 2003 12:37, ext-thierry.templier@ccf.com wrote:
> Hello,
>
> I try to make work this request:

Try:
select * from  ( select * from personne_nom where personne_nom_pal=1 ) as tmp,   left outer join  personne     on (
personne.personne_id= tmp.personne_nom_personne_id ) where personne_id=57
 

--  Richard Huxton Archonet Ltd