The natural join operator provides the ability to include nonmatching rows in the result table as well as matching rows.

Name: The natural join operator provides the ability to include nonmatching rows in the result table as well as matching rows.
Brand: Quizplus
Rating: 4.9 (37 reviews)

Question

Quizplus · Accepted Answer

The natural join operator only includes rows that have matching values in both tables being joined; it does not include nonmatching rows. Nonmatching rows can be included using outer joins, not natural joins.

The Natural Join Operator Provides the Ability to Include Nonmatching