pull in the customer information as part of the main query for efficiency