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