"Yaron" <yaroni@gmail.com> wrote in message
news:1107267206.063304.159240@z14g2000cwz.googlegr oups.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?
>

What does T1 have to do with your output? You could use a cursor to go
through the T2 table, but this sort of presentational work is usually best
handled by a reporting tool or other front end.

http://www.aspfaq.com/etiquette.asp?id=5006
http://tinyurl.com/bib2
http://groups.google.ch/groups?hl=en...%40127.0. 0.1

Simon