How to query more than one table
Creating JOINs
5. The keyword JOIN
Referencing columns
Let's practice

Instruction

Excellent! Now the result looks much better, right?

Joining two tables is such a popular and frequent operation that SQL provides a special word for it: JOIN. There are many versions of JOIN out there. For the time being, we'll focus on the basic one.

Exercise

Click Next exercise to proceed.