https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-using-unregistered-tables-query-layers/idi-p/1473535 <P><EM>ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:</EM></P><P>I have two standalone tables in an EGDB that are not registered with the geodatabase (Create Unregistered Table). The relationship is 1:M.</P><P>If I create a join using Add Join, the resulting join will be one-to-first (1:1), not one-to-many. Whereas, if the tables were registered with the geodatabase, then the relationship would be one-to-many.</P><P>Video:</P><P><div class="lia-vid-container video-embed-center"><div id="lia-vid-6353000867112w874h540r154" class="lia-video-brightcove-player-container"><video-js data-video-id="6353000867112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6353000867112w874h540r154'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6353000867112">(view in My Videos)</a></div></P><P>The docs say the requirements for 1:M joins are:</P><UL><LI>Both tables need ObjectIDs, which they have since the tables were created with the Create Unregistered Table tool.</LI><LI>Both tables need to be in the same workspace, which they are.</LI></UL><P>Could Pro be enhanced to support 1:M joins on&nbsp;unregistered tables, query layers, and database views?</P> Thu, 16 May 2024 14:04:02 GMT Bud 2024-05-16T14:04:02Z https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-using-unregistered-tables-query-layers/idi-p/1473535 <P><EM>ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:</EM></P><P>I have two standalone tables in an EGDB that are not registered with the geodatabase (Create Unregistered Table). The relationship is 1:M.</P><P>If I create a join using Add Join, the resulting join will be one-to-first (1:1), not one-to-many. Whereas, if the tables were registered with the geodatabase, then the relationship would be one-to-many.</P><P>Video:</P><P><div class="lia-vid-container video-embed-center"><div id="lia-vid-6353000867112w874h540r804" class="lia-video-brightcove-player-container"><video-js data-video-id="6353000867112" data-account="6161463677001" data-player="default" data-embed="default" class="vjs-fluid" controls="" data-application-id="" style="width: 100%; height: 100%;"></video-js></div><script src="https://players.brightcove.net/6161463677001/default_default/index.min.js"></script><script>(function() { var wrapper = document.getElementById('lia-vid-6353000867112w874h540r804'); var videoEl = wrapper ? wrapper.querySelector('video-js') : null; if (videoEl) { if (window.videojs) { window.videojs(videoEl).ready(function() { this.on('loadedmetadata', function() { this.el().querySelectorAll('.vjs-load-progress div[data-start]').forEach(function(bar) { bar.setAttribute('role', 'presentation'); bar.setAttribute('aria-hidden', 'true'); }); }); }); } }})();</script><a class="video-embed-link" href="https://community.esri.com/t5/video/gallerypage/video-id/6353000867112">(view in My Videos)</a></div></P><P>The docs say the requirements for 1:M joins are:</P><UL><LI>Both tables need ObjectIDs, which they have since the tables were created with the Create Unregistered Table tool.</LI><LI>Both tables need to be in the same workspace, which they are.</LI></UL><P>Could Pro be enhanced to support 1:M joins on&nbsp;unregistered tables, query layers, and database views?</P> Thu, 16 May 2024 14:04:02 GMT https://community.esri.com/t5/arcgis-pro-ideas/1-m-join-using-unregistered-tables-query-layers/idi-p/1473535 Bud 2024-05-16T14:04:02Z