DB:嵌套查询

UPDATE、DELETE 和 INSERT 语句中的子查询

可以在 UPDATE、DELETE、INSERT 和 SELECT 数据操作 (DML) 语句中嵌套子查询USE AdventureWorks;GO UPDATE Production.ProductSET ListPrice = ListPrice * 2WHERE ProductID IN    (SELECT ProductID      FROM Purchasing.ProductVendor     WHERE VendorID = 51);GO下面是一条使用联接的等效 UPDATE 语句：USE AdventureWorks;GO UPDATE Production.ProductSET ListPrice = ListPrice * 2FROM Production.Product AS pINNER JOIN Purchasing.ProductVendor AS pv    ON p.ProductID = pv.ProductID AND pv.VendorID = 51;GO