https://community.esri.com/t5/arcgis-pro-questions/join-table-to-featureclass-to-get-an-output/m-p/1332532#M73477 <P>Are you trying to do a "relate"?</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-relate.htm" target="_blank">Add Relate (Data Management)—ArcGIS Pro | Documentation</A></P> Tue, 26 Sep 2023 16:59:34 GMT DanPatterson 2023-09-26T16:59:34Z https://community.esri.com/t5/arcgis-pro-questions/join-table-to-featureclass-to-get-an-output/m-p/1332417#M73462 <P>I have a table with country information (multiple row for one country) and a feature class with all country polygons. As an output I would like to have the table as a polygon feature class. To join I can use the country name column. I tried it with the tool "Make Query Table" (I remember that in ArcMap this worked fine).&nbsp;</P><P>But I have no idea how this works in ArcPro. I thought that in the SQL Query I should write table.country = featureclass.country_name...</P><P>&nbsp;</P><P>Can someone help?</P> Tue, 26 Sep 2023 14:25:22 GMT https://community.esri.com/t5/arcgis-pro-questions/join-table-to-featureclass-to-get-an-output/m-p/1332417#M73462 KristinaSander 2023-09-26T14:25:22Z https://community.esri.com/t5/arcgis-pro-questions/join-table-to-featureclass-to-get-an-output/m-p/1332532#M73477 <P>Are you trying to do a "relate"?</P><P><A href="https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-relate.htm" target="_blank">Add Relate (Data Management)—ArcGIS Pro | Documentation</A></P> Tue, 26 Sep 2023 16:59:34 GMT https://community.esri.com/t5/arcgis-pro-questions/join-table-to-featureclass-to-get-an-output/m-p/1332532#M73477 DanPatterson 2023-09-26T16:59:34Z https://community.esri.com/t5/arcgis-pro-questions/join-table-to-featureclass-to-get-an-output/m-p/1332817#M73506 <P>Yes, I need to relate (n-1) from a table (N) to feature class (1) , but the output should be a feature class with same country polygons twice or more...&nbsp;</P> Wed, 27 Sep 2023 07:58:25 GMT https://community.esri.com/t5/arcgis-pro-questions/join-table-to-featureclass-to-get-an-output/m-p/1332817#M73506 KristinaSander 2023-09-27T07:58:25Z