I’m looking for the exact same thing - query joined collections (joined on reference field).
Datacollections allow you to access any field from the linked tables, but wix data query does not seem to support this from what I can tell.
Worst case scenario is going to be finding all the distinct values of your reference field in customer table, and then querying the reference table separately. That would be ridiculously inefficient though.