I'm using ArcMap and I have a One-to-Many relate between two tables, one table contains polygons, and the other has additional data. Multiple records in the additional data table relate to a single record in the polygon table. The tables contain historical information.

What I want to do is use a SQL statement on the additional information table to select only buildings dating to the 1800s, and use my relate to have only these buildings shown on the map.

I've looked through all the information I can find, but there doesn't seem to be an answer. Is it possible to do this?

  • A Definition Query (found in the layer properties) can limit the displayed items to just a SQL selection, however I don't know if this works across a relate.
    – smiller
    Jul 23, 2018 at 14:09

1 Answer 1


I discovered that the best way for me to do this would be to use a Query Table, and run Display Query on that table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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