Joins in MySQL

Joins are used in MySQL to combine rows from two or more tables based on a related column between them. The different types of joins in MySQL are:

• INNER JOIN : Returns all matching rows from both tables.
• LEFT JOIN : Returns all rows from the left table and matching rows from the right table.
• RIGHT JOIN : Returns all rows from the right table and matching rows from the left table.
• FULL OUTER JOIN : Returns all rows from both tables.
• CROSS JOIN : Returns the Cartesian product of the two tables.

Syntax and Examples :

• INNER JOIN :
SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name;

Example:


• LEFT JOIN :
SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name;

Example:


• RIGHT JOIN :
SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name;

Example:


• FULL OUTER JOIN :
SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name;

Example:


• CROSS JOIN :
SELECT column_name(s) FROM table1 CROSS JOIN table2;

Example: