select min record from many to many relationship

[eran ya]

Hi,

I would like to get minimum record from a many to many relationship where id equals to specific value

I have following tables"
product, supplier and product_has_supplier.
product table contains product_id and product_name column.
supplier table contains supplier_is, supplier_name
product_has_supplier table contains supplier_supplier_id, product_product_id and product_price.
I would like to get the min value of price for given product_id.
The select should also return supplier_name, product_price and product name.

Thanks