Methods of association between tables

Hala_Ghareeb

Hi all,

I was doing an exercise in an instructor-led course "Managing Geospatial data in ArcGIS", in page 3-13, the exercise was about defining the type of association: The last scenario says, "you have more than one matching record in the related table", which means the cardinality is 1:M so the compatible associations are Relationship Class and Relate. 

Why does the answer in page 3-25 include Join?

 

SuzanneBoden

Hi, in the ArcGIS Pro Help, I found this explanation:

When using data where a one-to-many or many-to-many relationship exists, use a relate or relationship class to establish the relationship between the datasets. However, you can create a join under these circumstances. When you create a join in such a case, there are differences between how tools and other layer-specific settings work depending on the data source. If you are using data in the same geodatabase to create the join, all matching records are returned. If you are using nondatabase data, such as shapefiles or dBASE tables, to create the join, only the first matching record is returned.