Set Operations
UNION, intersections ("INTERSECT"), difference ("EXCEPT")
- DO eliminate duplicates
- Use to connect whole sets (result of queries), not within WHERE
- EXCEPT not supported by MS Access 97
Division is not an SQL operation
Older SQL had a CONTAINS (set inclusion)