The join is between different workspaces. Performance is degraded due to the join being client side. Results from client side joins are always one to one. If both tables are in the same database, one-to-many can be supported and databases can be used to improve performance.
Use the Copy tool to copy one of the data sources to the other database.