Get to know the data
FULL JOIN
OUTER JOINS
NATURAL JOIN
Instruction
There's one more joining method before you go. It's called NATURAL JOIN and it's slightly different from the other methods because it doesn't require the ON clause with the joining condition:
SELECT * FROM person NATURAL JOIN car;
Check it yourself and try to guess how it works.
Exercise
Use a NATURAL JOIN on the student and room tables.
Stuck? Here's a hint!
Type:
SELECT * FROM student NATURAL JOIN room;
