In SQL, joins are used to combine rows from two or more tables based on a related condition between them. There are several types of joins, but the most important ones are: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
Next, I’ll show you how to use each one with examples.
The INNER JOIN returns only the rows that have a match in both tables.
Syntax:
The LEFT JOIN returns all rows from the left table and the matching rows from the right table. If there are no matches, it returns NULL in the columns from the right table.
Syntax:
The RIGHT JOIN returns all rows from the right table and the matching rows from the left table. If there are no matches, it returns NULL in the columns from the left table.
Syntax:
The FULL JOIN returns all rows when there is a match in one of the tables. If there are no matches, it returns NULL in the columns from the table that has no match.
Syntax:
