What is natural join in MySql

Natural join also known as Inner join.

R1 inner join R2

Those tuple of R1 will get combined with tuple of R2 if they have same value for the common attribute.

common attribute or column that have the same name in both table

Note-if in two table attribute same show common element from both table will be fetch.

Example 1

Output

A       B       C       D

X       10     100      L

Y       20     100     L

Z       30     200      M

Example 2

Output

A       B       C       D

X       10     100      L

Y       20     100     L

Z       30      200     M

X       10     100      T

Y       20     100     T