AnsweredAssumed Answered

How to see a Max Value in a joined view with a sub-query?

Question asked by on Aug 7, 2020

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.


Modified the view to change the usage to a subquery (select Max(usage) from tblCustomer;) as "Max Actual Usage".

The view represents fine in SQL Server.


When using a sub-query the join will not work in ArcMap (nor is a preview available in ArcCatalog).


I've read where attribute table joins cannot include a sub-query. 


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.