I have a question about how to relate two tables: Right now, I have a database that contains the address point and all details about the city. This database can be displayed as many spots on ArcGIS Pro. Also, I have another excel sheet that contains the different address of the restaurant. I have imported the excel sheet to my ArcGIS project as a table (called table 1) and used the standardized address to format the address so that these two table's data structure is the same. My question is that how do I relate these two tables by connecting (cross join) several fields such as "street name = street name and house number = house number", so that the data from the table 1 can only display on the map because it matches (or I can also say filter) with the database.
... View more