fancy select needed.Thanks for your help!

Hi,
I have a table like the following:
ID | Name
--
1 | Name 1
1 | Name 2
2 | Name 3
2 | Name 4
2 | Name 5
I now want to do a select which results in the following:
ID | Name
--
1 | Name 1, Name 2
2 | Name 3, Name 4, Name 5
Does anybody know how this could be done? Thank you a lot in advance!
DanielBetter to do it in your client app / reporting tool / programming language.
Do not stress the server.
AMB
"Daniel Walzenbach" wrote:

> Hi,
> I have a table like the following:
>
> ID | Name
> --
> 1 | Name 1
> 1 | Name 2
> 2 | Name 3
> 2 | Name 4
> 2 | Name 5
>
> I now want to do a select which results in the following:
> ID | Name
> --
> 1 | Name 1, Name 2
> 2 | Name 3, Name 4, Name 5
> Does anybody know how this could be done? Thank you a lot in advance!
> Daniel