SQL statement not working with Join

Question

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,

ThomasColson · Accepted Answer

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