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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly >
