Normal Set Operations (con’t.)
Difference of tables
- Result is the set of rows in one table but not the other
- Performed by using the SUBTRACT command
Product of two tables
- Mathematically called the Cartesian product
- Obtained by concatenating every row in first table with every row in second table