Project Operation

Projects vs operations - Differences and similarities - YouTube

• Builds a new table from the columns of an existing
table
• Specify name of exiting table and the columns
(field names) to be included in the new table
• Syntax: Project Field_List From Table
• The new table will have the number of columns
given in the operation, and the same number of
rows as the original table, unless
– The new table eliminates a key field; if the new table
has duplicate rows, the duplicates will be eliminated.

• Select keeps some rows, all columns
• Project keeps all rows, some columns
• Can use Select and Project operations
together to “trim” base tables, keeping
some of the rows and some columns.