SQL Server嵌套子查询的正确使用
作者:人工智能 来源:IT科技类资讯 浏览: 【大中小】 发布时间:2025-11-05 00:41:36 评论数:
复制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.