In the resulting layer or table view, the fields from the input layer or table view will be prefixed with the input's name and a period (.), and all fields from the join table will be prefixed with the join table name plus a period as the default. This only applies to layers table views cannot be saved in this manner. To persist the join for use in another session, save the layer to a layer file using the Save Layer To File tool. The join lasts only for the duration of the session. If a join with the same table name already exists-for example, if the layer A is joined to a table B-running the tool again to join table B will result in a warning that the join already exists. The Join Table is not required to contain an ObjectID field.įield properties, such as aliases, visibility, and number formatting, are maintained when a join is added or removed. The input layer or table view must have an ObjectID field.
The Join Table can be any of the following types of tables: a geodatabase table, a dBASE file, an INFO table, or an OLE DB table. If the target table is the attribute table of a layer, features that don't have data joined to them are not shown on the map. With the keep only matching records option, if a record in the target table doesn't have a match in the join table, that record is removed from the resultant target table. If a record in the target table doesn't have a match in the join table, that record is given null values for all the fields being appended into the target table from the join table. When joining tables, the default option is to keep all records.
For more information on one-to-one, many-to-one, one-to-many, and many-to-many joins, see About joining and relating tables. Records from the Join Table can be matched to more than one record in the input layer or table view. The input must be a feature layer, a table view, or a raster layer that has an attribute table it cannot be a feature class or table. A match is made when the input join field and output join field values are equal. The records in the Join Table are matched to the records in the input Layer Name. Joins a layer to another layer or table (where layer is a feature layer, table view, or raster layer with a raster attribute table) based on a common field.