AnsweredAssumed Answered

SQL statement not working with Join

Question asked by bulla_b on Jan 7, 2020
Latest reply on Jan 8, 2020 by bulla_b



I have a layer (Hydrants) in AGP that I have joined to another layer (1703).  I am trying to run a query to determine where the "Hydrants.Watermainsize" is not equal to the "1703.WATERMAINS" (watermainsize).


Here is my SQL in AGP:



In ArcMap this works with no problems.  Can anyone explain what might be happening in AGP??