SQL – Right Join
Table Of Contents:
- What Is SQL Right Join?
- Syntax Of SQL Right Join.
- Examples Of SQL Right Join.
(1) What Is SQL Right Join?
- The
RIGHT JOIN
keyword returns all records from the right table (table2), and the matching records from the left table (table1). The result is 0 records from the left side if there is no match.
![](https://www.praudyog.com/wp-content/uploads/2023/04/150.png)
(2) Syntax Of SQL Right Join
Syntax:
SELECT column_name(s)
FROM table1
RIGHT JOIN table2
ON table1.column_name = table2.column_name;
(3) Examples Of SQL Right Join
Order:
![](https://www.praudyog.com/wp-content/uploads/2023/04/151-1024x185.jpg)
Employees:
![](https://www.praudyog.com/wp-content/uploads/2023/04/152-1024x188.jpg)
Example-1:
SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
RIGHT JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID
ORDER BY Orders.OrderID;
Output:
![](https://www.praudyog.com/wp-content/uploads/2023/04/153-1024x271.jpg)
Customer:
![](https://www.praudyog.com/wp-content/uploads/2023/04/137-300x189.jpg)
Order:
![](https://www.praudyog.com/wp-content/uploads/2023/04/138-300x213.jpg)
Example-2:
select * from customer
right join product on customer.name = product.customer;
Output:
![](https://www.praudyog.com/wp-content/uploads/2023/04/140.jpg)