2-correlated-subquery.sql

SQL Server 2005基础教程一书的源代码.

SELECT ShareId,MaximumSharePrice
FROM ShareDetails.Shares
UPDATE ShareDetails.Shares
SET MaximumSharePrice = (SELECT MAX(Price)
                                           FROM ShareDetails.SharePrices sp
                               WHERE sp.ShareId = s.ShareId)
FROM ShareDetails.Shares s
SELECT ShareId,MaximumSharePrice
FROM ShareDetails.Shares