Query...

From: query <zzzz20007_at_gmail.com>
Date: Tue, 03 Jul 2007 03:54:14 -0000
Message-ID: <1183434854.441612.317430@g37g2000prf.googlegroups.com>

hi,
i have table with users and email-address. There can be multiple email-address for a user and there can be multipe users having same email-address.
eg: Table T1:

u1,e1
u2,e2
u2,e3
u3,e3
u3,e5
u4,e2
u5,e1
u6,e4

I need to build a table having users,email-addres and key. All users having same email address should have same key and all email address of these users should also have this same key. These email address may be shared by other users. they also should have the same key..This repeats..

The resultant table should be like the below...

u1,e1,k1
u2,e2,k2
u2,e3,k2
u3,e3,k2
u3,e5,k2
u4,e2,k2
u5,e1,k1
u6,e4,k3

Please find queries to build this table

Thanks in advance... Received on Mon Jul 02 2007 - 22:54:14 CDT