Get to know the data
6. Get to know the table equipment - continued
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
Aliases for tables

Instruction

Good. The table equipment is very much similar to the table student. It has three columns:

  • id - the id of the equipment piece,
  • name - which tells us what it is and
  • room_id - the room where we can find the piece of equipment.

Note that some pieces aren't assigned to any room - they are simply stored in the warehouse, if you're interested.

Exercise

Click Next exercise to continue.