SQL Right Join

SQL Right Join is used to return all data or records from the Table 2 plus match records to tables 1. If there is no match, the result from the left will be NULL.This is also known as RIGHT (OUTER) JOIN.

Right Join Syntax :

The syntax of the Right Join is −

SELECT column-name(s)
FROM table1
RIGHT JOIN table2
ON table1.column-name = table2.column-name;

SQL Right Join Example :

Consider the Customer table with the following records -

ID	Name	Age	Address	Salary
1	Aarav	36	Udaipur	35000
2	Vivaan	33	Mumbai	30000
3	Reyansh	28	Chennai	40000
4	Muhammad	29	Udaipur	50000
5	Sai	27	Mumbai	27000

Consider the Order table with the following records -

OID	Date	CustomerID	Amount
102	2019-10-08 00:00:00	3	3000
100	2019-10-08 00:00:00	3	1500
101	2019-11-20 00:00:00	2	1800
103	2018-05-20 00:00:00	4	2500

TEST CASE 1 :-Let us join these two tables using the Right JOIN as follows

SELECT  ID, Name, Amount, Date
FROM Customer
RIGHT JOIN Order
ON Customer.ID = Order.CustomerID;

The result for the respective sql query is as follows −

ID	Name	Amount	Date
3	Reyansh	3000	2019-10-08 00:00:00
3	Reyansh	1500	2019-10-08 00:00:00
2	Vivaan	1800	2019-11-20 00:00:00
4	Muhammad	2500	2018-05-20 00:00:00

Visit :

SQL Full Join

Discussion