topic Re: SQL statement not working with Join in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/sql-statement-not-working-with-join/m-p/174265#M7794 <HTML><HEAD></HEAD><BODY><P>This may be a typo, but you say your join is to a layer called "1703", yet your screen shot shows "1704". Just for giggles, delete the join, rename "170whatever" to something that has no numbers in it, re-do the join, and try the sql expression again. I have a suspicion.....</P></BODY></HTML> Wed, 08 Jan 2020 13:55:37 GMT ThomasColson 2020-01-08T13:55:37Z SQL statement not working with Join https://community.esri.com/t5/arcgis-pro-questions/sql-statement-not-working-with-join/m-p/174264#M7793 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a layer (Hydrants) in AGP that I have joined to another layer (1703).&nbsp; I am trying to run a query to determine where the "Hydrants.Watermainsize" is not equal to the "1703.WATERMAINS" (watermainsize).</P><P></P><P>Here is my SQL in AGP:</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/477531_pastedImage_1.png" /></P><P></P><P>In ArcMap this works with no problems.&nbsp; Can anyone explain what might be happening in AGP??</P><P></P><P>Thanks,</P></BODY></HTML> Tue, 07 Jan 2020 17:21:34 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-statement-not-working-with-join/m-p/174264#M7793 BrianBulla 2020-01-07T17:21:34Z Re: SQL statement not working with Join https://community.esri.com/t5/arcgis-pro-questions/sql-statement-not-working-with-join/m-p/174265#M7794 <HTML><HEAD></HEAD><BODY><P>This may be a typo, but you say your join is to a layer called "1703", yet your screen shot shows "1704". Just for giggles, delete the join, rename "170whatever" to something that has no numbers in it, re-do the join, and try the sql expression again. I have a suspicion.....</P></BODY></HTML> Wed, 08 Jan 2020 13:55:37 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-statement-not-working-with-join/m-p/174265#M7794 ThomasColson 2020-01-08T13:55:37Z Re: SQL statement not working with Join https://community.esri.com/t5/arcgis-pro-questions/sql-statement-not-working-with-join/m-p/174266#M7795 <HTML><HEAD></HEAD><BODY><P>Hi Thomas,</P><P></P><P>Yes, that was a typo.&nbsp; Going back and renaming the joined shapefile worked.&nbsp; Is it just an issue with there being any number in the table name?&nbsp; Or was the problem having it ALL numbers??</P></BODY></HTML> Wed, 08 Jan 2020 18:27:28 GMT https://community.esri.com/t5/arcgis-pro-questions/sql-statement-not-working-with-join/m-p/174266#M7795 BrianBulla 2020-01-08T18:27:28Z