I need to create a report that contains the contact information of the customers in our store that have purchased one specific product. Is there a way to create a SQL statement to get this information? Can anyone offer any help with regard to this? I did try the sales report add on but it only gave you the totals per product and that sort of thing....not the customer details.
Thank you in advance for any help you can offer.