problem with SELECT

[Steven Baker]

The problem:

tableproduct:
ID1 NAME
1 Product1
2 Product2

tablesupplier:
ID2 NAME
1 Acme1
2 Acme2

connectiontable:
Suplier Product Price
1 1 10
1 2 130
2 1 12
2 2 120

i am looking for a SELECT statement that produces:
Product1 10 Acme1
Product2 120 Acme2
These are the productname, the lowest price for the product and the supplier that offers it for the lowest price.


Thanks
Steven