SQL- Right Join

Right Join

In RIGHT JOIN if all records of RIGHT table are returuned by matching LEFT table.

If LEFT table is not matched the 'NULL' (no value) return.

Right Join

Syntax :-

SELECT   table1.column_name,  table.2column_name
FROM table_name1  RIGHT JOIN table_name2 
ON   table1.common_field  = table1.common_field;

Example :  figure in below, we have, two tables customers and orders.

 Now, let see join these two tables using the RIGHT JOIN as follows.

Query : 

SELECT Id, Name, Address

FROM customers RIGHT JOIN orders

ON customers.Id = orders.customers_Id;

Output :