Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BB79B9FA19B for ; Thu, 14 Dec 2006 11:37:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 03879-06 for ; Thu, 14 Dec 2006 11:37:04 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id 6E76C9FA178 for ; Thu, 14 Dec 2006 11:37:05 -0400 (AST) Received: from kingfisher.intern.logix-tt.com (84-72-188-217.dclient.hispeed.ch [84.72.188.217]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 929F164BFA for ; Thu, 14 Dec 2006 16:39:59 +0100 (CET) Received: from kingfisher.sec.intern.logix-tt.com (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 28478181C1B6B for ; Thu, 14 Dec 2006 16:37:01 +0100 (CET) Date: Thu, 14 Dec 2006 16:36:59 +0100 From: Markus Schaber To: pgsql-sql@postgresql.org Subject: Re: join and sort on 'best match' Message-ID: <20061214163659.088b7236@kingfisher.sec.intern.logix-tt.com> In-Reply-To: <682126990612140510j61d2268fq80235b02a550eccd@mail.gmail.com> References: <457FC751.6080104@code-shop.com> <1166005787.6369.79.camel@localhost.localdomain> <682126990612140510j61d2268fq80235b02a550eccd@mail.gmail.com> Organization: www.logix-tt.com X-Mailer: Sylpheed-Claws 2.6.0 (GTK+ 2.8.20; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/108 X-Sequence-Number: 27064 Hi, Ashish, "Ashish Ahlawat" wrote: > hi pls tell me ---- > > if table *Item 3 : news, nature, greenpeace, whale has all clmn y v need > join ??* Please try to write in English, so we can understand and answer your questions. Regards, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org