PostgreSQL Right Join

All the matched and unmatched records are retrieved from the table present on the right hand side of the join operators.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 Joins Syntax :

The syntax of the Right Joins statement is −


SELECT col_name,...
FROM table_name1 t1  [RIGHT] JOIN table_name2 t2
ON t1.col_name = t2.col_name

   



Postgresql 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 Postgresql 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 :


Discussion


* You must be logged in to add comment.