ArcGIS Pro 3.2.2; File Geodatabase
When using multiple tables in Make Query Table, the tool seems to perform a CROSS JOIN/Cartesian product. But you’d never know that by looking at the tool.
(To make the join one-to-many instead of a Cartesian product, we’d specify the join fields in the SQL expression, such as ASSET_ID = ASSET_ID.)
Could Make Query Table be enhanced to make it clear that it performs a CROSS JOIN?
How to join using Make Query Table?