I'm doing a simple query on a points feature class that has a table joined to it. I'm querying for values equal to 0 and my results are incorrect.

enter image description here

No coded domains, this is on ArcMap 10.5. Any explanation for this? Only caught it because I happened to check, but this would be terrible for any analysis.

  • 1
    Hope this doesn't sound dumb to you, but you can double-check that 1) you are looking at the right field? You seem to be working with the shapefiles and they have a limitation for 10 characters for the field 2) It's an integer field 3) Can you test running similar simple queries on other fields before join and after join, joining them and other fields? Aug 12, 2017 at 6:12

1 Answer 1


One explanation is that the field is actually a text field, which is very likely when using a table join.

Try changing the select query to "YourField" = '0' or ensure that the source table column is formatted as a number field and not text.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.