Inner Join

Understand the idea

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

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