If this procedure is done on a geodatabase with point data, the points will automatically be duplicated for each record that joined. Now click "Okay" and you should have a resulting table that is a one to many join.For some reason, you have to remove the quotes that ArcToolbox adds from the Expression field so that it reads Table1.join_field1 = Table2.join_field2.In the statement drop-down list, click SELECT. The output should look something like this: "Table1.join_field1" = "Table2.join_field2" Building a SELECT Statement On the Tools menu, click Query Builder.Double click the field from Table2 that will connect to Table1.Double click the field from Table1 that is supposed to join to Table2.Next to the "Expression" box, click on the SQL button.I usually click on "Select All" for the "Fields" so that all of my data comes along for the join.Select the correct "Input Tables" that you would like to perform the one to many join with.Keep all files in the same file geodatabase. I would also recommend converting your excel, csv, txt or whatever format your table resides in to an ESRI geodatabase table. From the Query Designer menu, point to Change Type, and then click Make Table. I would recommend converting your data to a geodatabase opposed to a shapefile. Add the source table or tables to the Diagram pane. After searching Google all day, I finally came up with a solution that I have outlined below. Each individual well (one) contained several different owners (many). My use for a one to many join came when I had a geodatabase of oil/gas well locations containing an ID that I needed to connect to my database (table) to retrieve owner information. All you need is your good ol' ArcToolbox in the less expensive desktop version of 10.2. But I have found that this is not the case.
#MAKE QUERY TABLE TOOL FULL#
I have had the need, on several occasions, to perform a one to many join in ArcMap but have always been told, "You can't do that with the desktop version, you need the full blown ArcInfo, or ArcSDE, etc.".
0 kommentar(er)
