Iha a table containing two columns x and y . for single value of x there are multiple values in y e.g
X Y
------------
1 ABC
2 PQR
3 XYZ
4 LMN
1 LMN
2 XYZ
I want a query that will give me following output
1 ABC:LMN
2 PQR:XYZ
3 XYZ
4 LMN
Any help will be really helpful
Thanks in advance
With Regards
Ashish
Why delete messages? Unlimited storage is just a click away.
