SELECT DISTINCT Sales.Customer.CustomerID, Sales.Store.Name
FROM Sales.Customer
JOIN Sales.Store
ON
( Sales.Customer.CustomerID = Sales.Store.CustomerID)
WHERE Sales.Customer.TerritoryID = 1
FROM Sales.Customer
JOIN Sales.Store
ON
( Sales.Customer.CustomerID = Sales.Store.CustomerID)
WHERE Sales.Customer.TerritoryID = 1
on 连接条件
where 可以换成 and