Normal Set Operations

• Union of two tables

  • Result contains all rows that are in either the first table, the second table, or both
  • Union compatible – tables are union compatible if they have the same number of columns and their corresponding columns represent the same type of data

• Intersection of two tables

  • Result contains all rows common to both
  • Use the INTERSECT command

Previous slide

Next slide

Back to first slide

View graphic version