Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (55.6k points)

Can anyone explain the Natural Join in MySQL?

1 Answer

0 votes
by (119k points)

In MySQL, the NATURAL JOIN is similar to INNER or LEFT JOIN but in Natural Join the ON clause refers to all columns that the tables to be joined have in common.

Here is the syntax to use Natural Join:

SELECT column_list

FROM table_1

NATURAL JOIN table_2;

If you want to learn MySQL from top professionals, then enroll in this SQL Training by Intellipaat.

Also, watch this video on MySQL:

 

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
+3 votes
1 answer
asked Jul 3, 2019 in SQL by Tech4ever (20.3k points)
+3 votes
1 answer
asked Jul 3, 2019 in SQL by Tech4ever (20.3k points)

Browse Categories

...