JOIN is used to retrieve data from two or more tables. By default JOIN is also called INNER JOIN. It is used with SELECT statement.

There are mainly two types of joins in MariaDB:

☛ INNER JOIN

☛ OUTER JOIN

Again OUTER JOIN is divided in two types:

☛ LEFT JOIN

☛ RIGHT JOIN