topic Re: Creating Table Query To Select Records with Partial Match Between Two Tables in Developers Questions

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

MJBiazar1 — Mon, 05 Mar 2018 18:05:41 GMT

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.

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

DanPatterson_Retired — Mon, 05 Mar 2018 18:41:46 GMT

Have you gone through the Select By Attributes tool options for expressions and wildcard to perform queries? (see also SQL reference for query expressions )

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

MJBiazar1 — Mon, 05 Mar 2018 20:13:59 GMT

I tried to use Create Query Table tool, but I didn't know how to write the expression in arcgis.

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

MJBiazar1 — Mon, 05 Mar 2018 20:18:49 GMT

Another problem is that I trying to do this query between a shapefile attribute and a table, so my table doesn't show up in Select by Attribute tool box.

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

DanPatterson_Retired — Mon, 05 Mar 2018 20:42:51 GMT

The 2nd and 3rd will help with how to write the queries, that's why they are there so you can see the similarities/differences between what you know and its implementation in ArcMap.

As for the Select by... stuff... Table Select... is the same thing but just for tables

All tools are available in ArcMap and PRO