通过Orders表中的ProductID连接Products表,获得ProductName;再通过
Orders表中的EmployeeID连接Employees表,获得LastName。
一定要考虑好用什么连接:
1.如果Products表<==>Employees表中存在对应记录,则用inner JOIN2.如果Products表<==>Employees表中不存在对应记录,则用left JOIN
SELECT o.*, p.ProductName, e.LastName
FROM Orders o INNER JOIN Products p ON o.ProductID = p.ProductID
INNER JOIN Employees e ON o.EmployeeID = e.EmployeeID