topic Enterprise Geodatabase Oracle join with Microsoft SQL Server View? in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-geodatabase-oracle-join-with-microsoft/m-p/268774#M10338 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have feature layer "<STRONG>Parcel"</STRONG> in enterprise geodatabase ORACLE and one "<STRONG>View"&nbsp;</STRONG>which is in Microsoft SQL Server.</P><P>I am trying join "<STRONG>View"</STRONG> with Parcel layer based on&nbsp;field&nbsp;"<STRONG>PIN</STRONG>", when I validate join in ArcMap, Join report says No matching records found, however there are 5 PINS are already present in feature layer "<STRONG>Parcel"</STRONG> and "V<STRONG>iew"</STRONG> in SQL Server.</P><P></P><P>Please suggest.</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/475347_pastedImage_7.png" /></P></BODY></HTML> Thu, 05 Dec 2019 08:12:40 GMT MayurDodiya 2019-12-05T08:12:40Z Enterprise Geodatabase Oracle join with Microsoft SQL Server View? https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-geodatabase-oracle-join-with-microsoft/m-p/268774#M10338 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have feature layer "<STRONG>Parcel"</STRONG> in enterprise geodatabase ORACLE and one "<STRONG>View"&nbsp;</STRONG>which is in Microsoft SQL Server.</P><P>I am trying join "<STRONG>View"</STRONG> with Parcel layer based on&nbsp;field&nbsp;"<STRONG>PIN</STRONG>", when I validate join in ArcMap, Join report says No matching records found, however there are 5 PINS are already present in feature layer "<STRONG>Parcel"</STRONG> and "V<STRONG>iew"</STRONG> in SQL Server.</P><P></P><P>Please suggest.</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/475347_pastedImage_7.png" /></P></BODY></HTML> Thu, 05 Dec 2019 08:12:40 GMT https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-geodatabase-oracle-join-with-microsoft/m-p/268774#M10338 MayurDodiya 2019-12-05T08:12:40Z