Re: [SQL] Left outer join and sub queries alias

2003-10-23 Thread Richard Huxton
On Thursday 23 October 2003 12:37, [EMAIL PROTECTED] 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 ) whe

[SQL] Left outer join and sub queries alias

2003-10-23 Thread ext-thierry . templier
Hello, I try to make work this request: select * from ( select * from personne_nom where personne_nom_pal=1 ) as tmp, personne left outer join tmp on ( personne.personne_id = tmp.personne_nom_personne_id ) where personne_id=57 The error on execution is: ERROR: Relation "tmp" doe