topic Merging tables from linked server and creating a spatial view in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/merging-tables-from-linked-server-and-creating-a/m-p/1613232#M42199 <P>I have two identical tables in different SQL Server databases that I would like to be able to merge into a single table in my GIS SQL Server database to be able to publish spatial views from in my Portal. I have the tables merged in my enterprise gdb but when it is joined I get random numbers appended to the join table field names, see below, the _20 is random. I cannot symbolize or label the features by the joined fields.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JeffMiller4_0-1746799593963.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/131870iFE94EF0D1BA3874D/image-size/medium?v=v2&amp;px=400" role="button" title="JeffMiller4_0-1746799593963.png" alt="JeffMiller4_0-1746799593963.png" /></span></P><P>This should work, shouldn't it?</P><P>&nbsp;</P> Fri, 09 May 2025 14:09:02 GMT JeffMiller4 2025-05-09T14:09:02Z Merging tables from linked server and creating a spatial view https://community.esri.com/t5/arcgis-enterprise-questions/merging-tables-from-linked-server-and-creating-a/m-p/1613232#M42199 <P>I have two identical tables in different SQL Server databases that I would like to be able to merge into a single table in my GIS SQL Server database to be able to publish spatial views from in my Portal. I have the tables merged in my enterprise gdb but when it is joined I get random numbers appended to the join table field names, see below, the _20 is random. I cannot symbolize or label the features by the joined fields.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="JeffMiller4_0-1746799593963.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/131870iFE94EF0D1BA3874D/image-size/medium?v=v2&amp;px=400" role="button" title="JeffMiller4_0-1746799593963.png" alt="JeffMiller4_0-1746799593963.png" /></span></P><P>This should work, shouldn't it?</P><P>&nbsp;</P> Fri, 09 May 2025 14:09:02 GMT https://community.esri.com/t5/arcgis-enterprise-questions/merging-tables-from-linked-server-and-creating-a/m-p/1613232#M42199 JeffMiller4 2025-05-09T14:09:02Z