https://community.esri.com/t5/arcgis-pro-questions/fgdb-join-from-table-to-database-view-join-fields/m-p/1287004#M68928 <P>Esri Case #03335352 - FGDB — Join from table to database view: Join fields are null</P><P>BUG-000158140: ArcGIS Pro: Join from table to database view generate Join fields with null values</P> Mon, 08 May 2023 20:54:51 GMT Bud 2023-05-08T20:54:51Z https://community.esri.com/t5/arcgis-pro-questions/fgdb-join-from-table-to-database-view-join-fields/m-p/1286775#M68893 <P><EM>ArcGIS Pro 3.1.1; file geodatabase<BR /><BR /></EM></P><P>I have a FGDB table called TEST_TABLE.</P><P>I've created a database view on the table called TEST_TABLE_NT_FLAG_VW:</P><PRE>select objectid, case when type = 'NT' then 1 else 0 end as flag from test_table </PRE><P>I've opened the table in the map and created a join via the OBJECTID.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_1-1683559121556.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/70120iA42E1714ADC2FB53/image-size/large?v=v2&amp;px=999" role="button" title="Bud_1-1683559121556.png" alt="Bud_1-1683559121556.png" /></span></P><P><BR /><U>Result:</U></P><P>The join didn't work. The join fields are null in the attribute table:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Bud_0-1683558803987.png" style="width: 999px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/70119i993A47E3F314E271/image-size/large?v=v2&amp;px=999" role="button" title="Bud_0-1683558803987.png" alt="Bud_0-1683558803987.png" /></span></P><P><U><BR />Video:</U></P><P><U><div class="lia-vid-container video-embed-center"><div id="lia-vid-6327043091112w864h540r251" class="lia-video-brightcove-player-container"><video-js data-video-id="6327043091112" 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-6327043091112w864h540r251'); 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/6327043091112">(view in My Videos)</a></div></U></P><P><U><BR />Question:</U></P><P>Why are the join fields blank in the FGDB join?</P><P>I don't have that problem in mobile or enterprise geodatabases.</P> Mon, 08 May 2023 15:32:45 GMT https://community.esri.com/t5/arcgis-pro-questions/fgdb-join-from-table-to-database-view-join-fields/m-p/1286775#M68893 Bud 2023-05-08T15:32:45Z https://community.esri.com/t5/arcgis-pro-questions/fgdb-join-from-table-to-database-view-join-fields/m-p/1287004#M68928 <P>Esri Case #03335352 - FGDB — Join from table to database view: Join fields are null</P><P>BUG-000158140: ArcGIS Pro: Join from table to database view generate Join fields with null values</P> Mon, 08 May 2023 20:54:51 GMT https://community.esri.com/t5/arcgis-pro-questions/fgdb-join-from-table-to-database-view-join-fields/m-p/1287004#M68928 Bud 2023-05-08T20:54:51Z