Get to know the data
4. Get to know the Student table – continued
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
Aliases for tables

Instruction

Excellent. There are only three columns in the Student table: ID, Name, and RoomID. The column ID is the identification number of each student in our table, Name is the full name of a student, and RoomID is the iD of the room in which a student lives. The room ID is, of course, taken from the Room table.

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

Okay, let's check the last table.

Exercise

Click Next exercise to continue.