SQL right-connected RIGHT JOIN keyword

SQL right link RIGHT JOIN keyword returns all rows of the right table (table2), even if there is no match on the left table (table1). If there is no match in the left table, the result is NULL.

SQL RIGHT JOIN syntax 

SELECT column_name(s)
FROM table1
RIGHT JOIN table2 ON table1.column_name = table2.column_name;

Note: In some databases, RIGHT JOIN is called RIGHT OUTER JOIN.

SQL right-connected RIGHT JOIN keyword


Demonstrate the database

In this tutorial, we'll use the famous Northwind sample database.

Here's an option in the Orders table:

OrderID CustomerID EmployeeID OrderDate ShipperID
10308 2 7 1996-09-18 3
10309 37 3 1996-09-19 1
10310 77 8 1996-09-20 2

And choose from the "Employees" table:

EmployeeID LastName FirstName BirthDate Photo
1 Davolio Nancy 12/8/1968 EmpID1.pic
2 Fuller Andrew 2/19/1952 EmpID2.pic
3 Leverling Janet 8/30/1963 EmpID3.pic

SQL RIGHT JOIN instance

The following SQL statement returns all employees and any orders they may have placed:

SELECT Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
RIGHT JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID
ORDER BY Orders.OrderID;

Note: The RIGHT JOIN keyword returns all rows of the right table (Employees), even if there is no match in the left table (Orders).