The example I posted was not the actual code, the actual code doesn't deal with customers at all. In any event, the actual data comes from a join between...

YES!!! Thank you so much, I've tried several variations but this is the combo that is working - the empty element name with GROUP BY on the outer query seems...