SQL Server嵌套子查询的独特功能
复制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.
本文地址：http://www.bzve.cn/html/476f9599428.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。