In Mysql, what is joins? Explain

In Mysql, joins are used to retrieve data from multiple tables. It is performed whenever two or more tables are joined.

There are three types of MySQL joins:-

• MySQL INNER JOIN
  SELECT columns FROM table_1 INNER JOIN table_2 ON table_1.column = table_2.column;
• MySQL LEFT JOIN
  SELECT columns FROM table_1 LEFT JOIN table_2 ON table_1.column = table_2.column;
• MySQL RIGHT JOIN
  SELECT columns FROM table_1 RIGHT JOIN table_2 ON table_1.column = table_2.column;