JOIN or INNER JOIN: Return only those 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.

OUTER JOIN: Return all the rows of both tables even there is no matches.