Database query help?

[filmfr3ak]

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!

[kobra]

Expand on how and where you need this
A manual off line method would be easier if sufficient

[filmfr3ak]

Im wanting to insert the query into phpmyadmin to export either an sql or a txt that can be converted to a pdf.

Basically what the printable pricelist mod does, only I need to be able to limit/sort by manufacturer not category. AND I need to do it via SQL not www so I can either do it online or local.

so kind of the printable pricelist + the manufacturer side box, as an sql query.

[kobra]

Im wanting to insert the query into phpmyadmin to export either an sql or a txt that can be converted to a pdf. only I need to be able to limit/sort by manufacturer not category.

Converting is up to what you have available for that...
add a select for the manufaturer

http://dev.mysql.com/doc/refman/5.0/en/select.html

[filmfr3ak]

Yea, I know how to export and convert.
What I need is the query.

Thanks for the link. Sadly, it might as well be in another language, because I dont understand that at all.