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