Inner Join Query

[obrienkev]

Hi all,

How do I get the instructor values from the below query?
If the instructor id is different in two rows then only one result overall will be returned.

How can I fix this?

$query = "SELECT * ".
			   "FROM class AS cl ".
				 "INNER JOIN ".
				 "course AS c ".
				 "ON cl.course_ID = c.course_ID ".
				 "INNER JOIN ".
				 "instructor AS i ".
				 "ON cl.instructor_ID = i.instructor_ID ".
				 "WHERE cl.course_ID = '$course' ".
				 "ORDER BY cl.class_ID ".
				 "DESC";