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.

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!


Leave a Reply

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