59
Union, Intersection, Difference
(
SELECT
name
FROM
Person
WHERE
City=“Seattle”)
UNION
(
SELECT
name
FROM
Person, Purchase
WHERE
buyer=name AND store=“The Bon”)
Similarly, you can use
INTERSECT
and
EXCEPT
.
You must have the same attribute names (otherwise: rename).