How do I join attribute tables in ArcGIS?
Joining attribute tables is relatively straightforward in ArcGIS. The key things to keep in mind are 1) what the id-field or join-field is that will be used and 2) whether the join is temporary join or a permanent join. The instructions here apply to working with coverages and geodatabases. Also, it assumes that the data to be joined is already in an INFO table (if working with coverages) or a geodatabase table (if working with a geodatabase). 1. Before the data is joined, the attribute table for the coverage (or geodatabase) will be absent of some or all of the data that is present in the INFO (or geodatabase) table that is to be joined to it. In order to join this data to the attribute table of the coverage, there must be a common attribute by which to join. 2. This can be accomplished by choosing an attribute from the INFO table (choose an attribute that contains a unique value for each record, for example, ‘CODE’, or when working with state data, the name of each state is a unique
Related Questions
- What is the difference between an association between logical tables, a load or select statement preceded by a join qualifier, and a join within a select statement?
- When I drag more than one table into a Brio query, the tables automatically join together with multiple lines. Whats going on?
- How do I use data from two DataTables in a single DataGrid to display join of the two tables?
