Lesson 12 of 20

Link tables with INNER JOIN and LEFT JOIN

Associate customers with their orders without losing sight of the keys and scope of the result.

24 minSQL Essentials

By the end of this lesson

  • Write a correct join condition
  • Choose between INNER JOIN and LEFT JOIN
  • Avoid unintentional multiplication of lines

SQL Essentials

Unlock this lesson and continue the path.

Link tables with INNER JOIN and LEFT JOIN is part of the complete programme: 20 lessons, 44 verifiable exercises and 2 published guided projects.

  • Complete content with explained examples
  • SQL simulator and expected result
  • Detailed answer, common mistakes and challenge
View SQL EssentialsI already have access
Six-month access, one-time payment and no automatic renewal.
Link tables with INNER JOIN and LEFT JOIN — SQL lesson — SQL.tn