Tell me what is JOIN? How many types of JOIN in MariaDB?

Submitted by: Muhammad
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
Submitted by: Muhammad

Read Online MariaDB Job Interview Questions And Answers