Summary - UNION and INTERSECT

Find rows in either or only one list with UNION and EXCEPT.

UNION combines, INTERSECT intersects, EXCEPT takes the difference. All require the same column count.

SELECT name FROM customers
UNION
SELECT name FROM suppliers;

Summary set operation.

name is selected from customers.

Exercise Summary - UNION and INTERSECT

Summary: combine customer and supplier names with UNION.

Show example solution

SELECT name FROM customers
UNION
SELECT name FROM suppliers;