From: | "David Sturtevant" <damagedcasesoftware(at)googlemail(dot)com> |
---|---|
To: | giuseppe(dot)derossi(at)email(dot)it |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: HELP, can't implement e filter |
Date: | 2007-08-20 13:40:50 |
Message-ID: | f7018c970708200640ked2b3b1qaef46cda2dc32106@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(dot)derossi(at)email(dot)it <giuseppe(dot)derossi(at)email(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pallav Kalva | 2007-08-20 13:44:24 | Re: Invalid String enlargement |
Previous Message | cipher | 2007-08-20 11:45:19 | Re: SOS. Database Lost |