Set Operations
Set union ?, intersection ?, difference ?
- on compatible relations: corresponding columns have same types
Note there is no "set complement"!
- What would the complement of a table be??
- Databases tend to operate on a "closed world" assumption: "If it's not in the DB, it doesn't exist."
- In Prolog: "If you can't prove it, it isn't true."