Hi all,
I have the following tables:

T1
==
ID Name
-- ----
1 Name1
2 Name2
T2
==
ID Color
-- ----
1 Color1
1 Color2
2 Color2
2 Color3

and I would like to get the following output (without duplicates):

ID Colors
-- ------
1 Color1, Color2
2 Color2, Color3

Is it possible?