My table contains the details like with two fields:
User ID Rolename
1 Editor
1 Reviewer
7 EIC
7 Editor
7 Reviewer
19 EIC
19 Editor
19 Reviewer
I want get the unique details with RoleName
like
1 Editor,Reviewer
7 EIC,Editor,Reviewer
How to combine RoleName
Details? How to write the Query?