topic How to see a Max Value in a joined view with a sub-query? in ArcMap Questions https://community.esri.com/t5/arcmap-questions/how-to-see-a-max-value-in-a-joined-view-with-a-sub/m-p/747255#M1517 <HTML><HEAD></HEAD><BODY><P>Attribute table for natural gas meters is joined to a view in my billing system so when a user clicks on the map they can see the customers usage. So far all works.</P><P></P><P>Modified the view to change the usage to a subquery (select Max(usage) from tblCustomer;) as "Max Actual Usage".</P><P>The view represents fine in SQL Server.</P><P></P><P>When using a sub-query the join will not work in ArcMap (nor is a preview available in ArcCatalog).</P><P></P><P>I've read where attribute table joins cannot include a sub-query.&nbsp;</P><P></P><P>Anyone have an idea for a workaround? We have a business case to see the Meter on the map and the maximum usage the customer has ever experienced.</P></BODY></HTML> Fri, 07 Aug 2020 19:16:53 GMT ScottMinter 2020-08-07T19:16:53Z How to see a Max Value in a joined view with a sub-query? https://community.esri.com/t5/arcmap-questions/how-to-see-a-max-value-in-a-joined-view-with-a-sub/m-p/747255#M1517 <HTML><HEAD></HEAD><BODY><P>Attribute table for natural gas meters is joined to a view in my billing system so when a user clicks on the map they can see the customers usage. So far all works.</P><P></P><P>Modified the view to change the usage to a subquery (select Max(usage) from tblCustomer;) as "Max Actual Usage".</P><P>The view represents fine in SQL Server.</P><P></P><P>When using a sub-query the join will not work in ArcMap (nor is a preview available in ArcCatalog).</P><P></P><P>I've read where attribute table joins cannot include a sub-query.&nbsp;</P><P></P><P>Anyone have an idea for a workaround? We have a business case to see the Meter on the map and the maximum usage the customer has ever experienced.</P></BODY></HTML> Fri, 07 Aug 2020 19:16:53 GMT https://community.esri.com/t5/arcmap-questions/how-to-see-a-max-value-in-a-joined-view-with-a-sub/m-p/747255#M1517 ScottMinter 2020-08-07T19:16:53Z