How many types of JOIN are there in MariaDB?

There are basically two types of JOIN in MariaDB.

1. Inner join: Inner join is a type of join works only when the conditions are satisfied. It is used to recover the rows from two or more tables.
2. Outer join: It has further two types: -

• I)LEFT JOIN: In the same way of INNER JOIN, it also works on those rows in a table where the particular conditions are satisfied. LEFT OUTER JOIN is basically useful at the time of recovering those rows which have to be carried from the left-hand table but in ON condition. It is also referred as LEFT OUTER JOIN.
• 2)RIGHT JOIN: It also works on those rows in a table where the particular conditions are satisfied. RIGHT OUTER JOIN is basically useful at the time of recovering those rows which have to be carried from the right-hand table but in ON condition. It is also referred to as RIGHT OUTER JOIN.