Lesson 3 of 3 · 12 min

Joining tables

JOIN combines tables on a shared column: orders JOIN customers ON orders.customer_id = customers.id.

INNER JOIN keeps only matches; LEFT JOIN keeps all rows from the left table.

Practice

Sketch two tables (students, courses) and write the JOIN that lists each student with their course.

Optional resources

No purchase or partner signup is required to complete this course or earn quiz points.

These are official product links, not active affiliate links. Learnly does not currently earn a commission from them.

Explore guided SQL exercises alongside your queries.

Limited free content; full course access may require payment.

Test small SQL examples using fictional sample data.

Browser SQL playground; never paste private or personal data.