I have two tables they are
1) student(student_no (primary Key) ,student_name)
2) phoneDetails(student_no (Foreign Key,phone no)
student table has the records like this
1 raj
2 rani
3 babu
phonedetails table has the records like this
1 3434556
2 4555667
1 4567566
3 5678908
2 5623468
2 1234565
A student can have multiple no of phone numbers,I would like to get these numbers in comma separated values,
I would like to get the result as
1 raj 3434556,4567566
2 rani 4555667,5623468,1234565
3 babu 5678908
Please help me through SQL Server queries.