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 01DFDD1DB35 for ; Wed, 14 Apr 2004 17:41:50 -0300 (ADT) 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 99646-05 for ; Wed, 14 Apr 2004 17:41:50 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id 92638D1DA83 for ; Wed, 14 Apr 2004 17:41:47 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id i3EKem1p015307; Wed, 14 Apr 2004 14:40:49 -0600 (MDT) Date: Wed, 14 Apr 2004 14:39:52 -0600 (MDT) From: "scott.marlowe" To: Tina Messmann Cc: Subject: Re: full join...using and version of pgsql In-Reply-To: <407D6F75.8040804@xinux.de> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-IHS-MailScanner-Envelope-Sender: scott.marlowe@ihs.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/129 X-Sequence-Number: 17504 On Wed, 14 Apr 2004, Tina Messmann wrote: > hello list, > > i am using pgsql 7.2.1 > i need something like > > select * from t1 full join t2 using(bla) full join t3 using(bla) > > i searched the archives and found that this is not possible with my > version of postgres. > is this implemented in newer versions of postgres? since which version? > > i'll try the alternative select * from t1 full join t2 on(t1.bla=t2.bla) > full join t3 on(t1/t2.bla=t3.bla) > but this is not the best solution for me i think.... I think you are looking for a natural join.