Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D78D69F980D for ; Mon, 20 Aug 2007 11:06:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 60663-04 for ; Mon, 20 Aug 2007 11:06:37 -0300 (ADT) X-Greylist: delayed 00:25:45.050704 by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id 8ACD19F9823 for ; Mon, 20 Aug 2007 11:06:37 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id v27so755416wah for ; Mon, 20 Aug 2007 07:06:36 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=googlemail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=tScYQrlJVYLmXlj7QpRmKqfKVbaDvhbZiXskaxWIrKyI/gZcVUndAAxn2LoNXWvbD/2FG05hbtCHujuu3YBjkvTy19RoZ/cCiQZiaZ5Ihq34QZi2NVhoKdcL0noKXklTll0c//qAVdlkHtKsvnx1zymKr0ObFtLxe+aVmvZFtmo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=fjMvGPRY6RdOs5IYPcIAssgQhGJdzQPgRCHaO/1SVOpjitL9iU3yfu2T4wEs6O2sE+o2rmf0fVc9ZGLqU4stopEzRIl6iRvlB5poa8MSPtViqh7w39c3DChqbyJPrszthF5dDzT1No9zDGagJLyio3FNMzp7eOhrwWSN6C60+ic= Received: by 10.114.175.16 with SMTP id x16mr3025266wae.1187617250161; Mon, 20 Aug 2007 06:40:50 -0700 (PDT) Received: by 10.114.173.10 with HTTP; Mon, 20 Aug 2007 06:40:49 -0700 (PDT) Message-ID: Date: Mon, 20 Aug 2007 14:40:50 +0100 From: "David Sturtevant" To: giuseppe.derossi@email.it Subject: Re: HELP, can't implement e filter Cc: pgsql-admin@postgresql.org In-Reply-To: <5721d54f0ab9128f6c815295a036b0f4@83.225.9.51> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_97825_26110862.1187617250112" References: <5721d54f0ab9128f6c815295a036b0f4@83.225.9.51> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200708/224 X-Sequence-Number: 26555 ------=_Part_97825_26110862.1187617250112 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline If I understand you right I think what you want is select c1,c2,c3,c4,c5 from table1 intersect select c1,c2,c3,c4,c5 from table2 On 19/08/07, giuseppe.derossi@email.it wrote: > > Hi, > I need to implement a filter in order to select from the first table the > second one... > it could be simple, but i'm wasting time. Please, is there anyone could > help > me? > thanks in advance > Giu > > c1 c2 c3 c4 c5 > 1)133659;1;"0039";"00121";7 > 2)133664;1;"0039";"00121";12 > 3)133664;2;"0039";"00121";12 > 4)133665;2;"0039";"00121";12 > 5)135460;1;"0039";"01152"; > 6)135460;2;"0039";"01152"; > 7)135471;1;"0050";"00153";4 > 8)135471;2;"0050";"00153";4 > > > 1)133659;1;"0039";"00121";7 > 3)133664;2;"0039";"00121";12 > 4)133665;2;"0039";"00121";12 > 6)135460;2;"0039";"01152"; > 8)135471;2;"0050";"00153";4 > -- > Email.it, the professional e-mail, gratis per te: http://www.email.it/f > > Sponsor: > Una settimana da sogno nelle pi=F9 belle localit=E0 di vacanza, con > Mondolastminute trovi ogni settimana l'offerta che fa per te! > Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3D6852&d=3D200708= 19 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ------=_Part_97825_26110862.1187617250112 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline If I understand you right I think what you want is

select c1,c2,c3,= c4,c5 from table1 intersect select c1,c2,c3,c4,c5 from table2

<= span class=3D"gmail_quote">On 19/08/07, giuseppe.derossi@email.it <giuseppe.derossi@email.it> wrote:
Hi,
I need to implement a filter in order to select from the first table= the
second one...
it could be simple, but i'm wasting time. Plea= se, is there anyone could help
me?
thanks in advance
Giu

  c1     c2 c3     c4&nbs= p;    c5
1)133659;1;"0039";"00121";7<= br>2)133664;1;"0039";"00121";12
3)133664;2;"003= 9";"00121";12
4)133665;2;"0039";"00121&quo= t;;12
5)135460;1;"0039";"01152";
6)135460;2;"0039= ";"01152";
7)135471;1;"0050";"00153";= 4
8)135471;2;"0050";"00153";4


1)133659;1;= "0039";"00121";7
3)133664;2;"0039";"00121";12
4)133665;2;"00= 39";"00121";12
6)135460;2;"0039";"01152&qu= ot;;
8)135471;2;"0050";"00153";4
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f

Sponsor:
Una settimana d= a sogno nelle pi=F9 belle localit=E0 di vacanza, con
Mondolastminute tro= vi ogni settimana l'offerta che fa per te!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=3D6852&am= p;d=3D20070819



---------------------------(end of broadc= ast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate       subscribe-nomail command to majordomo@postgresql.org so that y= our
       message can get through to the = mailing list cleanly

------=_Part_97825_26110862.1187617250112--