FIT100: Fluency with Information Technology

FIT100

Tables From Tables

There are five fundamental operations on tables to create tables:

•Select -- pick rows from a table

•Project -- pick columns from a table

•Union -- combine two tables w/like columns

•Difference -- remove one table from another

•Product -- create “all pairs” from two tables

Though not primitive “Join” is usually included