6

I have a table with several fields. field A contains the same kind of values as does field B. I tried to select all points where the value in field A does not exist in anywhere field B using query builder in select by attribute.

For example

ID A  B
1  a  b
2  b  c
3  c  a
4  d  b

It should select the points with ID 4 since value d does not exist in field B. I think I should use a subquery, but how?

Improve this question

2 Answers 2

Reset to default
5

If you use "IN" you can use a sub query that produces a list of all B values.Try:

NOT A IN (SELECT B FROM TABLE_NAME)
Improve this answer
3

You should use the subquery:

FieldA not in (select FieldB from tablename)

When using the Select By Attributes tool.

ArcGIS Help page.

Improve this answer
2
  • I did not know of this query before, very interesting to know!
    – ed.hank
    Commented Oct 29, 2015 at 13:44
  • 1
    Be careful if/when working with versioned data in ArcSDE databases. In these cases you need to ensure that the data in your subquery is a versioned view - resources.arcgis.com/EN/HELP/MAIN/10.1/index.html#//…. Otherwise, your query may return incorrect results.
    – Brent Edwards
    Commented Oct 29, 2015 at 14:31

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.