AnsweredAssumed Answered

Creating Table Query To Select Records with Partial Match Between Two Tables

Question asked by mj.biazar on Mar 5, 2018
Latest reply on Mar 5, 2018 by Dan_Patterson

Hi everybody,


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.