Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Get to know the data
4. Get to know the student table – continued
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
Aliases for tables

## Instruction

Excellent. There are only three columns in the student table: id, name, and room_id. The column id is the identification number of each student in our table, name is the full name of the student. room_id is the id of the room which the student lives in. The room id is, of course, taken from the room table.

If you examine the student table close enough, you'll find out that some students don't have a room assigned to them. Remember this detail – we'll make use of this information later on.

Ok, let's check the last table.

## Exercise

Click to continue.