Chapter 5 Exercise 25

25. Using a UNION query, list the employees who painted bicycles on March 15, 2012 or framed them on that date (StartDate) (or both). Hint: Join the Employee table to Painter and then to FrameAssembler.

SELECT Employee.EmployeeID, Employee.LastName, Bicycle.StartDate
FROM Employee INNER JOIN Bicycle ON Employee.EmployeeID = Bicycle.FrameAssembler
WHERE (((Bicycle.StartDate)=#3/15/2012#))
UNION
SELECT Employee.EmployeeID, Employee.LastName, Bicycle.StartDate
FROM Employee INNER JOIN Bicycle ON Employee.EmployeeID = Bicycle.Painter
WHERE (((Bicycle.StartDate)=#3/15/2012#))