The RIGHT JOIN clause is used to join multiple tables, return all rows from the right table(table2) and the matched rows from the left table(table1). Non matched rows from table1 will return nulls.
SELECT
column_name1,column_name2,...
FROM table_name1
RIGHT JOIN table_name2 ON join_condition;Here we are going to use RIGHT JOIN to show customers and their addresses.
