61
Subqueries
•A subquery producing a single value:
•
•
•
•
•
•
•In this case, the subquery returns one value.
•
•If it returns more, it’s a run-time error.
SELECT Purchase.product
FROM     Purchase
WHERE  buyer =
                 (SELECT  name
                   FROM     Person
                   WHERE   ssn = ‘123456789‘);