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.
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?
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)
You should use the subquery:
FieldA not in (select FieldB from tablename)
When using the Select By Attributes tool.
ArcGIS Help page.