How to combine 3 result rows in mysql

[HAKAN]

Hi

I am learning MySQL in that i want to combine 3 result rows is anyone know how to do that. Can anyone provide me query that i will use in SQL .


Thanks

[FAIRFAX]

Can you provide us table information. so we will come to know what exactly you want.

[HAKAN]

Here is table which i want to join

Table 1: Student
Student_id int
Student_name varchar
-other fields

Table 2: Student_profiles
Student_profiles_id int
Student_id int
sub_name int


Table 3: Course
Course_id int
Student_id int
sub_name int

[FAIRFAX]

Try this query :

SELECT DISTINCT s.student_id, s.student_name
FROM student s
JOIN student_profiles up
ON s.student_id = sp.student_id
JOIN student_matches_profiles ump
ON sc.sub_name int = sc.sub_name int AND
ump.answer_id = up.answer_id