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.