2011

Your selection is the secondary source. If this source contains multiple
tables, choose the one to use for the join.
4 In the This Column From The Left Table list, select the join key (the
common field or property) for the primary source, for example, Parcel_ID
or County_Name.
5 In the Matches This Column From The Right Table list, select the
matching field or property in the secondary source.
Only fields with matching data types are displayed in the right-hand list.
The fields need not have the same name in both data sources, but they
must have the same data type (numeric, string, Boolean, and so on). For
example, you can match the Parcel_ID field in one table to the
Lot_Number field in the second table, so long as Parcel_ID and
Lot_Number use the same data type.
6 Under Type Of Joins, select the type of join to create:
■ Keep All Records On The Left (a left outer join)
■ Keep Only Left-Side Records With A Match (an inner join)
7 Under Relationship With Secondary Records (Cardinality), choose one
of the following:
■ One-To-One matches one secondary source record to each primary
source item. Any extra secondary source records are ignored.
■ One-To-Many creates a new feature for each extra record in the
secondary source.
8 Click OK.
In the
Data Table (page 1125) for the primary source (the feature layer to which
you joined the data), the newly joined properties are appended to the right
of the native feature data. The joined properties are gray, to indicate that they
are read-only. In the column title, the name of the table you joined precedes
the property name.
NOTE To edit joined data, you must edit the secondary source itself, and not the
layer to which it is joined. See
Editing Joined Data (page 515).
Quick Reference
MAPDEFINEJOIN
Creating a Join | 513