0 votes
1 view
in SQL by (30.7k points)

Can anyone explain the Natural Join in MySQL?

1 Answer

0 votes
by (72.4k 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
asked Jun 26 in SQL by Sudhir_1997 (30.7k points)
0 votes
1 answer
asked Jun 26 in SQL by Sudhir_1997 (30.7k points)
0 votes
1 answer
asked Jun 26 in SQL by Sudhir_1997 (30.7k points)
0 votes
1 answer
asked Jun 26 in SQL by Sudhir_1997 (30.7k points)
0 votes
1 answer
asked Jun 26 in SQL by Sudhir_1997 (30.7k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...