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.

Outcomes