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

[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 )
  where personne_id=57

-- 
  Richard Huxton
  Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])