RIGHT JOIN/RIGHT OUTER JOIN clause select all the records from right table(table2) and the matching records from the left table(table1).

Syntax of RIGHT JOIN in SQL-

SELECT <column_name(s)>

FROM <table1>

RIGHT JOIN<table2>

ON <table1.column_name=table2.column_name>WHERE<condition>;

Example of RIGHT JOIN in SQL-

SELECT Customers.CustomerName, Orders.OrderID

FROMCustomers

RIGHT JOIN Orders

ONOrders.CustomerID = Customers.CustomerID;

RIGHT JOIN returns all records from the right table (Orders), even if there are no matches in the right table (Customers). In the above example, the SQL statement will select all orders, and their customers.