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.
(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:
Employees:
Example-1:
SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
RIGHT JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID
ORDER BY Orders.OrderID;
Output:
Customer:
Order:
Example-2:
select * from customer
right join product on customer.name = product.customer;