pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>

view thread (5+ messages)  latest in thread

Message-ID: <f7018c970708200640ked2b3b1qaef46cda2dc32106@mail.gmail.com>
Permalink:  ../f7018c970708200640ked2b3b1qaef46cda2dc32106@mail.gmail.com/
Also on:    postgresql.org/message-id/f7018c970708200640ked2b3b1qaef46cda2dc32106@mail.gmail.com

 · 

reply

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