topic Re: how can I get the joined table field name to query the layer,after layer,table jo in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/how-can-i-get-the-joined-table-field-name-to-query/m-p/205587#M5367 <HTML><HEAD></HEAD><BODY><SPAN>You are missing the part where you show how you get the featurePin...&nbsp; Are you getting it from IFeatureLayer.FeatureClass.search or from IGeoFeatureLayer.DisplayFeatureClass.Search?&nbsp; The former includes only the fields in the base feature class, the latter includes the join fields as per the documentation.</SPAN></BODY></HTML> Tue, 18 Jun 2013 11:50:50 GMT AlexanderGray 2013-06-18T11:50:50Z how can I get the joined table field name to query the layer,after layer,table joined https://community.esri.com/t5/arcobjects-sdk-questions/how-can-i-get-the-joined-table-field-name-to-query/m-p/205586#M5366 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN><SPAN>I am able to programmatically&nbsp; join a layer and a table, the way suggest at "</SPAN><A class="jive-link-external-small" href="http://help.arcgis.com/en/sdk/10.0/vba_desktop/conceptualhelp/index.html#/How_to_join_a_table_to_a_layer_in_ArcMap/00010000008t000000/" rel="nofollow" target="_blank">http://help.arcgis.com/en/sdk/10.0/vba_desktop/conceptualhelp/index.html#/How_to_join_a_table_to_a_layer_in_ArcMap/00010000008t000000/</A><SPAN>".</SPAN></SPAN><BR /><BR /><SPAN>I need to now programatically get only the rows that were joined. or the count of the rows only joined. ie. if the layer had a "CITYID" field&nbsp; joined to "CID" field of the table. may be only 10 rows had the same "CITYID" as the table.</SPAN><BR /><BR /><SPAN>or how can I refer the "CID" after the join in the where clause of the layer query. If I use</SPAN><BR /><BR /><SPAN> featurePin.Fields.FindField("CITY.CID") it returns '-1' ie. the cfield does not exists.</SPAN><BR /><BR /><SPAN>how can I get the joined table field name&nbsp; to query the layer, after the layer and table were join</SPAN><BR /><SPAN>ed programmatically(VBA)?</SPAN><BR /><BR /><SPAN>Thanks.</SPAN></BODY></HTML> Tue, 18 Jun 2013 07:50:17 GMT https://community.esri.com/t5/arcobjects-sdk-questions/how-can-i-get-the-joined-table-field-name-to-query/m-p/205586#M5366 arct 2013-06-18T07:50:17Z Re: how can I get the joined table field name to query the layer,after layer,table jo https://community.esri.com/t5/arcobjects-sdk-questions/how-can-i-get-the-joined-table-field-name-to-query/m-p/205587#M5367 <HTML><HEAD></HEAD><BODY><SPAN>You are missing the part where you show how you get the featurePin...&nbsp; Are you getting it from IFeatureLayer.FeatureClass.search or from IGeoFeatureLayer.DisplayFeatureClass.Search?&nbsp; The former includes only the fields in the base feature class, the latter includes the join fields as per the documentation.</SPAN></BODY></HTML> Tue, 18 Jun 2013 11:50:50 GMT https://community.esri.com/t5/arcobjects-sdk-questions/how-can-i-get-the-joined-table-field-name-to-query/m-p/205587#M5367 AlexanderGray 2013-06-18T11:50:50Z