query help

[uYe]

Hi,
I have a table with product_name, price field. The product name may be exist
in more than one record. I only want to view the product per product name
which has the lowest price. Please help me to  build such query, many thanks
for your helps.

Regards


Willy