Re: HELP, can't implement e filter

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
>

In response to

Browse pgsql-admin by date

  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