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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]