duplicates by default, unless DISTINCT is given. • Set operators UNION, INTERSECT, EXCEPT use set semanFcs by default! • To use bag semanFcs: UNION ALL, INTERSECT ALL, EXCEPT ALL. Lipyeow Lim -‐-‐ University of Hawaii at Manoa 2 (SELECT title, year FROM Movies) UNION ALL (SELECT movieTitle AS title, movieYear AS year FROM StarsIn)