I have 2 tables:
Student table with Id, Name fields
Phone table with Id,StudentId,PhoneNumber
Now, I want to show student list with all it's phone numbers in 1 row.
this query: "select student.*, phone.* from student inner join phone on student.id=phone.studentid" shows me the list of students with duplicate per each phone number.
I want something like this:
1 paul 66665566,7766665
2 ben 5566556,8877667
3 sam 4444334,3454332,7656765
View Complete Post