复制USE AdventureWorks ; GO SELECT DISTINCT c.LastName,套查 c.FirstName FROM Person.Contact c JOIN HumanResources.Employee e ON e.ContactID = c.ContactID WHERE EmployeeID IN (SELECT SalesPersonID FROM Sales.SalesOrderHeader WHERE SalesOrderID IN (SELECT SalesOrderID FROM Sales.SalesOrderDetail WHERE ProductID IN (SELECT ProductID FROM Production. Product p WHERE ProductNumber LIKEFW%))); GO 1.2.3.4.5.6. |
喜欢
讨厌