What is join in MySql

It is a way to combine information from two or more relations. it is a binary relation(two relations to operate).

There are four types-

1-Cross join(Cross product / cartition products)

2-Natural join

3-Outer join

4-Self join