MySQL Right Join

 

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.

 




Subscribe To Our Newsletter
You will receive our latest post and tutorial.
Thank you for subscribing!

required
required


Leave a Reply

Your email address will not be published. Required fields are marked *