I'm trying to do a table query to select partial matching records between a table and a shapefile attribute in arcmap. I have two tables and I want to find records in table1 that has exact match in field C with the same field in table2.
I'm working in personal geodatabase and I executed this query in MS Access using this sql query:
The result table should be something like this:
I just wanted to know how can I do this in arcmap.
Thank you for your time in advance.