1:M Join — Input and join table in different workspaces

[Bud]

Could the Add Join geoprocessing tool be enhanced so that it supports one-to-many joins between Esri datatypes (.sde, feature services and .gdb) even if the input and join table are not in the same workspace?

Add Join (Data Management)

The input table must have an Object ID field to perform a one-to-many join and be in the same workspace.

Related:

• https://community.esri.com/t5/arcgis-pro-ideas/option-to-create-one-to-many-join/idc-p/1267341/highl...
• ENH-000151081

Thanks.