Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Get to know the data
JOIN revisited
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOINS
NATURAL JOIN
17. NATURAL JOIN
Aliases for tables

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;