SQL - LEFT and RIGHT JOIN
Given these tables:
id | name
1 | Dave
2 | Emma
3 | Frank
student_id | course
1 | Math
3 | Science
What will be the output of this query?
Studentsid | name
1 | Dave
2 | Emma
3 | Frank
Enrollmentsstudent_id | course
1 | Math
3 | Science
What will be the output of this query?
SELECT Students.name, Enrollments.course FROM Students LEFT JOIN Enrollments ON Students.id = Enrollments.student_id;