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

Hi,

 

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??

 

Thanks,

Outcomes