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

08-07-2020 12:16 PM
New Contributor III

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.

0 Kudos
0 Replies