topic Query related table and join attributes from feature? in Data Management Questions https://community.esri.com/t5/data-management-questions/query-related-table-and-join-attributes-from/m-p/547393#M31038 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: #ffffff;">I have a related table I'm querying based on a date field but I want to include the attributes from the feature it is related to. Any ideas?</SPAN></P></BODY></HTML> Fri, 28 Sep 2018 22:42:04 GMT Anonymous User 2018-09-28T22:42:04Z Query related table and join attributes from feature? https://community.esri.com/t5/data-management-questions/query-related-table-and-join-attributes-from/m-p/547393#M31038 <HTML><HEAD></HEAD><BODY><P><SPAN style="background-color: #ffffff;">I have a related table I'm querying based on a date field but I want to include the attributes from the feature it is related to. Any ideas?</SPAN></P></BODY></HTML> Fri, 28 Sep 2018 22:42:04 GMT https://community.esri.com/t5/data-management-questions/query-related-table-and-join-attributes-from/m-p/547393#M31038 Anonymous User 2018-09-28T22:42:04Z Re: Query related table and join attributes from feature? https://community.esri.com/t5/data-management-questions/query-related-table-and-join-attributes-from/m-p/547394#M31039 <HTML><HEAD></HEAD><BODY><P>To look at it?&nbsp;<A class="link-titled" href="http://pro.arcgis.com/en/pro-app/help/data/tables/automatically-select-related-records.htm" title="http://pro.arcgis.com/en/pro-app/help/data/tables/automatically-select-related-records.htm">Automatically select related records—ArcGIS Pro | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Sat, 29 Sep 2018 00:28:00 GMT https://community.esri.com/t5/data-management-questions/query-related-table-and-join-attributes-from/m-p/547394#M31039 DanPatterson_Retired 2018-09-29T00:28:00Z Re: Query related table and join attributes from feature? https://community.esri.com/t5/data-management-questions/query-related-table-and-join-attributes-from/m-p/547395#M31040 <HTML><HEAD></HEAD><BODY><P>You questions is broad and vague.&nbsp; Are the records in the related table in a Many to One relationship with the features (Table Many Records -&gt; Feature Class One Feature)?&nbsp; If so you can use a standard join in memory to view the feature attributes in the table view.&nbsp; If you want to create labels on the feature class features using the table attributes, which is in a One to Many&nbsp;or Many to Many relationship, see my Blog on <A _jive_internal="true" href="https://community.esri.com/blogs/richard_fairhurst/2015/02/07/creating-labels-with-related-table-data">Creating Labels with Related Table Data</A>.&nbsp; If you want to permanently join the attributes to the table you can do a standard join and export to a new table, or add fields that match the feature class and use the techniques in my Blog on <A _jive_internal="true" href="https://community.esri.com/blogs/richard_fairhurst/2014/11/08/turbo-charging-data-manipulation-with-python-cursors-and-dictionaries">Turbo Charging Data Manipulation&nbsp;With Python Cursors and Dictionaries</A>&nbsp;to populate the fields from the feature class.&nbsp; Anyway, if you mean something else, please give details.&nbsp;</P></BODY></HTML> Sat, 29 Sep 2018 00:35:07 GMT https://community.esri.com/t5/data-management-questions/query-related-table-and-join-attributes-from/m-p/547395#M31040 RichardFairhurst 2018-09-29T00:35:07Z