Re: Query...

query schrieb:
> 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...
>

If i understand your requirement correctly, then you can try to apply the solution suggested by Volder
http://forums.oracle.com/forums/thread.jspa?threadID=515435&tstart=0&messageID=1882685#1882685 Otherwise, please, post table creation scripts, some test data and desired output.

Best regards

Maxim Received on Tue Jul 03 2007 - 03:23:28 CDT