PROBLEM
Attempts to join a field in ArcMap fail, as ArcMap is unable to recognize the join field from both the feature attribute table and the join table.
The data types of the join fields do not match. For example, a numeric data type and a float data type cannot be joined as the data types of the fields are not the same. This is by design, as ArcMap does not allow two different field data types to be joined.
Get help from ArcGIS experts
Download the Esri Support App