SELECT s.name, c.name
FROM students s
FULL JOIN enrollments e ON s.id = e.student_id
FULL JOIN courses c ON e.course_id = c.id;
This is my statement, but it throws an error code 1064: You have an error in your sql syntax; check the manual that correspond to your MySQL server version for the right syntax to use near line 3.
The MySQL version i am using is 8.0.
Please help I am stuck.
I have tried researching for the right syntax but to no avail, it seems as this is the right syntax.
tried to put the semicolon on line 3 as EOF.
Louis Malale is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.