Skip
Arish's avatar

178. FULL OUTER JOIN


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.