FULL OUTER JOIN
Returns all rows from both tables.
sql
1SELECT s.name, c.course_name
2FROM students s
3FULL OUTER JOIN courses c ON s.course_id = c.id;Shows all students AND all courses.

Returns all rows from both tables.
1SELECT s.name, c.course_name
2FROM students s
3FULL OUTER JOIN courses c ON s.course_id = c.id;Shows all students AND all courses.