Joins

Combine tables correctly: inner and outer joins, many-to-many links and spotting duplicated rows.

  1. 01

    Inner and Left Joins

    • easy
  2. 02

    Find the Missing Rows

    • easy
    • Pro
  3. 03

    Many-to-Many with a Join Table

    • medium
    • Pro
  4. 04

    Why Did My Totals Double?

    • medium
    • Pro
  5. 05

    Self Joins

    • medium
    • Pro
  6. 06

    How the Database Joins

    • hard
    • Pro