Cant sorting when use group by : I Have two table :
1- Products (id, product_name, option)
2- Prices (id, name, price, shop, available)
Each product can have several prices that each shop enters.

I want select products and sort them by price low to high

But this code not work correctly :

Select
product_name,
Prices.price 
FROM Products
LEFT JOIN Prices ON Prices.name=Products.product_name AND Prices.available="yes"
GROUP BY product_name
ORDER BY Prices.price
LIMIT 0,10

The above code at first Group products by name then sort them price
And its my problem.

**I dont want to show one product a few times**

Is there any solution?