SQL. Join (Inner, Left, Right and FullJoins) A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them.

SQL. Join (Inner, Left, Right and FullJoins) A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them.

You can use multiple tables in your single SQL query. The act of joining inMySQL refers to smashing two or more tables into a single table. You can use JOINS in the SELECT, UPDATE and DELETE statements to join theMySQL tables. We will see an example of the LEFT JOIN also which is different from the simple MySQL JOIN.