Bugl — Daily coding puzzles and drills

RIGHT JOIN Keyword

Right Join

The RIGHT JOIN

command returns all rows from the right table, and the matching records from the left table. The result is NULL from the left side, when there is no match. The following SQL will return all employees, and any orders they might have placed:

Example

SELECT Orders.OrderID, Employees.LastName, Employees.FirstName

FROM Orders

Formula

RIGHT JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID

ORDER BY Orders.OrderID;

Note:

The RIGHT JOIN

keyword returns all records from the right table (Employees), even if there are no matches in the left table (Orders).

SQL RIGHT JOIN Keyword

SQL RIGHT JOIN Keyword

RIGHT JOIN Keyword

Previous

Next

Right Join

The RIGHT JOIN

Example

FROM Orders

Note:

The RIGHT JOIN

Previous

Next

SQL RIGHT JOIN Keyword

SQL RIGHT JOIN Keyword

RIGHT JOIN Keyword

Previous

Next

Right Join

The RIGHT JOIN

Example

FROM Orders

Note:

The RIGHT JOIN

Previous

Next