X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7A88FD1B4F2 for ; Thu, 23 Oct 2003 12:18:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 36684-07 for ; Thu, 23 Oct 2003 09:18:11 -0300 (ADT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id A0222D1B4EF for ; Thu, 23 Oct 2003 09:18:07 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1) id 1ACePo-000LB7-0Z; Thu, 23 Oct 2003 13:18:08 +0100 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 2FB0317899; Thu, 23 Oct 2003 13:18:07 +0100 (BST) Received: from client17.archonet.com (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 922E916D5F; Thu, 23 Oct 2003 13:18:06 +0100 (BST) From: Richard Huxton To: ext-thierry.templier@ccf.com, "PGSQL" Subject: Re: Left outer join and sub queries alias Date: Thu, 23 Oct 2003 13:18:05 +0100 User-Agent: KMail/1.5 References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200310231318.05704.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/306 X-Sequence-Number: 15706 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