在Access中使用INNER JOIN

在NORTHWIND中，
=========================
SELECT

 Orders.OrderID AS 订单号,
 Customers.ContactName AS 客户姓名,
 (Employees.FirstName + " " + Employees.LastName) AS 雇员姓名
FROM
 Customers

INNER JOIN
(
 Orders

 INNER JOIN

  Employees

 ON
  Employees.EmployeeID = Orders.EmployeeID
)
ON
 Orders.CustomerID = Customers.CustomerID