From: David Sturtevant <damagedcasesoftware@googlemail.com>
To: giuseppe.derossi@email.it
Cc: pgsql-admin@postgresql.org
Subject: Re: HELP, can't implement e filter
Date: Mon, 20 Aug 2007 14:40:50 +0100
Message-ID: <f7018c970708200640ked2b3b1qaef46cda2dc32106@mail.gmail.com> (raw)
In-Reply-To: <5721d54f0ab9128f6c815295a036b0f4@83.225.9.51>
References: <5721d54f0ab9128f6c815295a036b0f4@83.225.9.51>
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 <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ù belle località di vacanza, con
> Mondolastminute trovi ogni settimana l'offerta che fa per te!
> Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6852&d=20070819
>
>
>
> ---------------------------(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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: damagedcasesoftware@googlemail.com, giuseppe.derossi@email.it
Subject: Re: HELP, can't implement e filter
In-Reply-To: <f7018c970708200640ked2b3b1qaef46cda2dc32106@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox