I'm new to ArcGIS and was wondering if someone could help me with my SQL expression. Essentially, I'm using ModelBuilder to iterate over several tables and Make Query table for each one. I'm trying to join my tables to shapefiles.
Normally what I would do as far as the SQL expression is: column_name_of_table = column_name_of_my_shapefile
This would work just fine if I use the Make Query table one at a time for each table.
However, I'm having an issue with the SQL expression when I try to iterate over multiple tables.
The column name that I'm using to join to the shapefile colmun name are exactly the same, however the name of the Table itself is not.
For example, I have 4 tables labeled:
They all share the same field name for the field that I want to join to the shapefile.
Each field name is named Locality.
That means that the actual field name is
The shapefile's field name always stays the same,
So when I try to write the SQL expression and iterate it
Out0.Locality = MSA.Locality
will not work for Out1.Locality = MSA.Locality or so on.
How could I fix it so that the SQL expression is consistent regardless of the table name?