《现代数据库管理(英文版)》课件—07.pptVIP

* Show all orders that include furniture finished in natural ash SELECT DISTINCT OrderID FROM OrderLine_T WHERE EXISTS (SELECT * FROM Product_T WHERE ProductID = OrderLine_T.ProductID AND Productfinish = ‘Natural ash’); Correlated Subquery Example The subquery is testing for a value that comes from the outer query The EXISTS operator will return a TRUE value if the subquery resulted in a non-empty set, otherwise it returns a FALSE ? A correlated subquery always refers to an attribute from a table referenced in the outer query * Figure 7-7b Processing a correlated subquery Subquery