SQL help to create a report of customers who purchased a specific product....

[friends1976]

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.

[data_digger]

SELECT DISTINCT c.*
FROM customers c, orders o, orders_products op
WHERE c.customers_id = o.customers_id
AND o.orders_id = op.orders_id
AND op.products_id = YOUR_PRODUCT_ID