Re: Left outer join and sub queries alias

From: Richard Huxton <dev(at)archonet(dot)com>
To: ext-thierry(dot)templier(at)ccf(dot)com, "PGSQL" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Left outer join and sub queries alias
Date: 2003-10-23 12:18:05
Message-ID: 200310231318.05704.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thursday 23 October 2003 12:37, ext-thierry(dot)templier(at)ccf(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Gamache 2003-10-23 15:29:44 Re: Query planner: current_* vs. explicit date
Previous Message ext-thierry.templier 2003-10-23 11:37:26 Left outer join and sub queries alias