Joins and Relates

There are two ways to combine tables: Joins and Relates.

Joins are used for 1-to-1 relationships, or many-to-1 relationships between the attribute table and an external table.

Relates are used for 1-to-many relationships, or many-to-many relationships between the attribute table and an external table.

Table Join

Table Join:
Combines two tables based on the value of a field that can be found in both tables (a "common field").

Join Examples in ESRI ArcMap

Relate Examples in ESRI ArcMap

Summarize

Summarize creates a new table containing one record for each unique value occurring in a selected field along with statistics summarizing the data in any of the other fields.

Group together all records that have the same State name. Get summary stats on the values in the rain field.

Test Your Knowledge

 

Additional Resources

< Back Next >