在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