The FULL JOIN keyword return rows when there is a match in one of the tables.
Dec 25
Dec 18
The RIGHT JOIN keyword Return all rows from the right table (table_name2), even if there are no matches in the left table (table_name1).
Dec 11
The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).
Dec 04
The INNER JOIN keyword return rows when there is at least one match in both tables.