Many to many relationship class with ArcGIS Desktop using only two table

Question

In database discussions, for creating many to many relationship class we must create a third table to relate two other tables.

However, in ArcGIS for creating many to many relationship class we just introduce two tables.

How does ArcGIS create a many to many relationship class without a third table?

forexample we have this issue

"A user can belong to multiple community, and a community can have multiple users"

forexample in "table to relationship class" tool we have three tables

and because ArcGIS does not know which origin objects are associated with which destination objects, so you must manually populate the rows

so we must have third table to link two others

this is the link that describe it

https://desktop.arcgis.com/en/arcmap/10.3/manage-data/relationships/populating-an-attributed-relationship-class-table-.htm

Answer 1

It doesn't. It does create a 3rd table. ArcGIS creates a wide variety of tables in its databases that it does not expose to the user in the user interface of ArcMap or ArcGIS Pro. The additional table for a relationship class is just one of them.

The documentation for creating a relationship class explicitly states:

For many-to-many relationship classes, a new table is created in the database to store the foreign keys used to link the origin and destination classes.

https://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/create-relationship-class.htm

(Other tables it can create in databases that are not directly exposed to the user include versioning add/delete/update tables, archive history tables.)