I have a table in a geodatabase that I would like to join to a feature class. The table contains well locations with multiple sample dates and associated data, however, I am only interested in sample events that occurred in August. I applied a definition query to the table, but when I tried to join it to the feature class it failed. I removed the definition query and tried to join again and it was successful, but joined the data was based on the earliest sample event (February). I am working with ArcGIS Desktop v10.3. Is it possible to apply a definition query to a table and join it to a feature class?
- apply the query to the table and export selected results
- join the new exported table with desired attributes to Feature Class.
- Export the feature class with the join to a new Feature Class.