Need query to select orders by manufacturer id.
and return a list of customer names and addresses who have made orders from the specified manufacturer.

I've been trying to write an sql query to export a list of mailing addresses of customers who have purchased from specified manufacturers.

I can paste the query into my database myself, I just cant come up with a query that works. Everything I do pulls ALL of the addresses not ones that bought from that manufacturer only.

the effected tables and fields are: {I think}

zen_address_book >
customers_id
entry_firstname
entry_lastname
entry_street_address
entry_city
entry_postcode


zen_orders >
customers_id
orders_id

zen_orders_products >
orders_id
products_id

zen_products >
products_id
manufacturers_id


any ideas???