W3. SQL Right Join

Question 1

Q: What does the SQL RIGHT JOIN keyword do?

Answer 1

A: It returns all records from the right table and the matching records from the left table. If there’s no match, it returns 0 records from the left side.

Question 2

Q: Write the syntax for a RIGHT JOIN.

Answer 2

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

Question 3

Q: What is another name for RIGHT JOIN in some databases?

Answer 3

A: RIGHT OUTER JOIN

Question 4

Q: Write a query to return all employees and any orders they may have placed, ordered by OrderID.

Answer 4

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

Question 5

Q: What happens in a RIGHT JOIN if there is no matching record in the left table?

Answer 5

A: The result will include all records from the right table, and 0 (NULL) for columns from the left table with no match.