https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-input-and-join-table-in-different/idi-p/1279974 <P>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?<BR /><BR /></P><BLOCKQUOTE><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm#:~:text=and%20be%20in%20the%20same%20workspace" target="_self">Add Join (Data Management)</A></P><P><SPAN>The input table must have an Object ID field to perform a one-to-many join <STRONG>and be in the same workspace.</STRONG></SPAN></P></BLOCKQUOTE><P><SPAN>Related:</SPAN></P><UL><LI><SPAN><A href="https://community.esri.com/t5/arcgis-pro-ideas/option-to-create-one-to-many-join/idc-p/1267341/highlight/true#M23757" target="_blank" rel="noopener">https://community.esri.com/t5/arcgis-pro-ideas/option-to-create-one-to-many-join/idc-p/1267341/highlight/true#M23757</A></SPAN></LI><LI><SPAN>ENH-000151081</SPAN></LI></UL><P><SPAN><BR />Thanks.</SPAN></P> Thu, 01 Jun 2023 19:39:39 GMT Bud 2023-06-01T19:39:39Z https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-input-and-join-table-in-different/idi-p/1279974 <P>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?<BR /><BR /></P><BLOCKQUOTE><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm#:~:text=and%20be%20in%20the%20same%20workspace" target="_self">Add Join (Data Management)</A></P><P><SPAN>The input table must have an Object ID field to perform a one-to-many join <STRONG>and be in the same workspace.</STRONG></SPAN></P></BLOCKQUOTE><P><SPAN>Related:</SPAN></P><UL><LI><SPAN><A href="https://community.esri.com/t5/arcgis-pro-ideas/option-to-create-one-to-many-join/idc-p/1267341/highlight/true#M23757" target="_blank" rel="noopener">https://community.esri.com/t5/arcgis-pro-ideas/option-to-create-one-to-many-join/idc-p/1267341/highlight/true#M23757</A></SPAN></LI><LI><SPAN>ENH-000151081</SPAN></LI></UL><P><SPAN><BR />Thanks.</SPAN></P> Thu, 01 Jun 2023 19:39:39 GMT https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-input-and-join-table-in-different/idi-p/1279974 Bud 2023-06-01T19:39:39Z