2 tables in one grid view query problem C# VS2008,MSSQL2005

See more:

VS2008

C#

SQL-Server

, +

Here is the thing. I have created two tables called "User" and "Phone".In User table there are two columns "id" and "name".since one user has more than one phone number I've created another table called "Phone" as mentioned above. so phone table contains all the telephone numbers of each user.

User table         
id-------name       
100-----jack       
200-----john       
                   
                   
phone table
id-------phone
100-----12345
100-----23456
200-----34567
200-----45678

So now i want to load those two tables to a single grid view as below (Visual studio 2008,C#)

name-----phone       
jack-------12345,23456       
john-------34567,45678 

I wrote a query as

SELECT U.name,P.phone
FROM tUser U,tPhone P 
WHERE U.id = P.id

But I'm getting the output as below

name-----phone       
jack-------12345
jack-------23456       
john-------34567
john-------45678 

What should I do now? Is it not possible or is there any other way to get the correct output? I'm Waiting for a positive reply. Thanks..