BuildBot

SQL, Refreshed

Joins

Lesson 3 of 5

A join stitches rows from two tables together wherever a key matches.

What you'll learn

  • Relate rows across tables with INNER JOIN
  • Contrast INNER JOIN with LEFT JOIN
  • See how foreign keys make joins meaningful
Members only

A free account unlocks this lesson and every other one.

Runnable challenges, knowledge checks, and progress that syncs across your devices. No card needed.

Not sure yet? Try the free lesson first: Tables, types & constraints