Is This Content Helpful?
We're glad to know this article was helpful.
When data is joined in ArcMap using the default 'Keep all records' option some rows may have no data values. This occurs when a row in the destination table doesn't have a matching row in the source table.
Steps to create a query that selects the rows with no data values in a joined field and returns null values.
tableB.fieldB is Null and FeatureClassA.OBJECTID is Not Null
Because the OBJECTID field does not allow Nulls, the 'FeatureClassA.OBJECTID is Not Null' part of the query will return True for all rows.