Different SQL JOINs

Different SQL JOINs

Before we continue with examples, we will list the types of JOIN you can use, and the differences between them.

JOIN: 

Return rows when there is at least one match in both tables

LEFT JOIN: 

Return all rows from the left table, even if there are no matches in the right table

RIGHT JOIN: 

Return all rows from the right table, even if there are no matches in the left table

FULL JOIN: 

Return rows when there is a match in one of the tables