Search results

hi, it worked like this: SELECT b.subject_name, a.first_name, a.last_name FROM (subjects b LEFT JOIN students_subjects c ON b.subject_id=c.subject_id) LEFT JOIN students a ON c.student_id=a.student_id ORDER BY b.subject_name; thank's for your help, it was...

hi all, i am trying to run this query: SELECT b.subject_name, a.first_name, a.last_name FROM subjects b LEFT JOIN students_subjects c ON b.subject_id = c.subject_id LEFT JOIN students a ON c.student_id = a.student_id but getting this error...