Get to know the data
JOIN revisited
LEFT JOIN
12. LEFT JOIN again
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
Aliases for tables

Instruction

Well done! It wasn't easy.

Let's practise some more!

Exercise

Select all pieces of equipment together with room they are assigned to. Show each piece of equipment even if it isn't assigned to a room.

Stuck? Here's a hint!

Type:

SELECT
  * 
FROM equipment 
LEFT JOIN room 
  ON equipment.room_id = room.id;