SQL RIGHT JOIN

SQL RIGHT JOIN

This is a detailed tutorial of SQL RIGHT JOIN. Learn to fetch all records from the RIGHT database table that matches with the records from the LEFT table.

Use of SQL RIGHT JOIN

SQL RIGHT JOIN will fetch all the records from the RIGHT database table for which the records of the LEFT database table share a common column value for a number of records. If in case, a value of the RIGHT database table is not contained in the JOINING column of the LEFT database table, the records will still be fetched but the not found values will be fetched as NULL records. Again, this may seem a bit complicated to beginners, but after having a look at examples, you’ll be clear of this concept.

SQL RIGHT JOIN Representation

Note. RIGHT JOIN and RIGHT OUTER JOIN are the same. It’s just that in some databases, we have to use the full keyword RIGHT OUTER JOIN instead of RIGHT JOIN.

RIGHT JOIN Syntax

In the above syntax of RIGHT JOIN, we’re using a SQL SELECT Statement to fetch all of the records from the table_2 and also the matching records values from the table_1 on the basis of the joining column present in both tables i.e. column_x. If the record values for column_x are not present in the table_1, then the record values from the second table still are fetched but as NULL.

Example

For the demonstration query of RIGHT JOIN, we’ll use the two demo database tables employees and salaries. These tables have one common column emp_no that will be used for RIGHT JOINING both of these tables. The following two screenshots give a quick look at the columns and data of these two tables. Observe them carefully.

Demo Database Table Salaries
Database Table salaries (LEFT TABLE)
Demo Database Table Employees
Database Table employees (RIGHT TABLE)

Note. We’ve used the same database tables as we’ve used in the SQL LEFT JOIN example. We’ve just flipped the tables. In other words, we’re now assuming the LEFT table as RIGHT and RIGHT as LEFT.

The following query will fetch all the records from the RIGHT database table employees and also the matching record values from the LEFT database table salaries on the basis of JOINING column emp_no.

Observe the result set screenshot of the above query carefully.

SQL RIGHT JOIN Example

As you can see in the salaries table, there are no records for emp_no 10001 and 10003, therefore the value of the salary column is fetched as NULL in the resultset of the RIGHT JOIN query. Therefore, this example justifies the working of SQL RIGHT JOIN query.

I hope you find this guide useful. If so, do share it with others who are willing to learn SQL. If you have any questions related to this article, feel free to ask them in the comments section.

Also, don’t forget to Subscribe to WTMatter!

Subscribe To WTMatter!

Receive updates of our latest articles via email. Enter your email address below to get started.

Leave a Reply

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