I have a strange problem.

Im needing a query that will Result in being able to export a list of products {product name, price, description} from a specific manufacturer.

Example would be like all products listed for Manufacturer A.

My Sql knowledge is very limited.

I know I need to query the zen_products table to get the product id's for all of manufacturer As products. But I dont know how to get it to use those ID's to pull all the needed info from the zen_product_description table.

any help appreciated.
Thanks!