Left Join

Understand the idea

In this lesson, explore left join. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

SELECT s.name,e.course_id FROM students s LEFT JOIN enrollments e ON e.student_id=s.id;