Getting data from multiple rows into one column

See more:

SQL-server-2000

SQL-Server

Hi All,
I have 2 tables in SQL Sever 2000.
Tables contains data as follows
Table1 (User Id & their role)
User_Id Role
1 a
1 b
1 c
2 a
2 b
2 d
2 f
3 c
3 d
3 e
and so on.
Table2(Role List)
Role
a
b
c
d
e
f
g
h
I need a create a query that will give me output like this:
User_Id Role
1 a,b,c
2 a,b,d,f
3 c,d,e
with 1 condition
Where Table1.Role = Table2.Role
Thanks & Regards
Suveen Mohan