Skip
Arish's avatar

179. Practice - FULL JOIN

Exercise: Complete Picture

Get all students and courses.

Solution

sql
1-- PostgreSQL
2SELECT s.name, c.course_name
3FROM students s
4FULL OUTER JOIN courses c ON s.course_id = c.id;