sql query syntax

From: <yaroni_at_gmail.com>
Date: 1 Feb 2005 06:16:50 -0800
Message-ID: <1107267410.587545.236980@f14g2000cwb.googlegroups.com>

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? Received on Tue Feb 01 2005 - 08:16:50 CST