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

Continue with the right access

“Link tables with INNER JOIN and LEFT JOIN” is included from SQL Essentials.

30 free days of SQL Pro on registration, subject to the 33 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.
Link tables with INNER JOIN and LEFT JOIN — SQL lesson — SQL.tn