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).

Previous slide

Next slide

Back to first slide

View graphic version