Tables
Table 1: Employees
EmployeeID |
LastName |
FirstName |
BirthDate |
Photo |
8 |
Callahan |
Laura |
1/9/1958 |
EmpID8.pic |
9 |
Dodsworth |
Anne |
7/2/1969 |
EmpID9.pic |
10 |
West |
Adam |
9/19/1928 |
EmpID10.pic |
Table 2: Orders
OrderID |
CustomerID |
EmployeeID |
OrderDate |
ShipperID |
10255 |
68 |
9 |
7/12/1996 |
3 |
10262 |
65 |
8 |
7/22/1996 |
3 |
10263 |
20 |
9 |
7/23/1996 |
3 |
10268 |
33 |
8 |
7/30/1996 |
3 |
Note: There is no record with EmployeeID = 10 (West Adam).
Query
If you need a place to try this query, try here: https://www.w3schools.com/sql/trysql.asp?filename=trysql_op_in
SELECT Orders.OrderID, Employees.LastName, Employees.FirstName FROM Orders RIGHT JOIN Employees ON Orders.EmployeeID = Employees.EmployeeID WHERE Employees.EmployeeID IS NULL ORDER BY Orders.OrderID;
Result
OrderID |
LastName |
FirstName |
NULL |
West |
Adam |