Subquery in select by attribute in Arcgis

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?

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


You should use the subquery:

FieldA not in (select FieldB from tablename)

When using the Select By Attributes tool.

ArcGIS Help page.

Watch the video: ARC GIS Select By Location TUTORIAL (October 2021).