AnsweredAssumed Answered

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

Question asked by sminter@langd.org 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.

Outcomes