62
•Can say the same thing without a subquery:
•
•
•
•
•
•This is equivalent to the previous one when the ssn is a key
and ‘123456789’ exists in the database;
otherwise they are different.
SELECT Purchase.product
FROM     Purchase, Person
WHERE  buyer = name AND ssn = ‘123456789‘