November 17th, 2012, 10:02 AM
Join Date: Nov 2012
Time spent in forums: 22 m 19 sec
Reputation Power: 0
Now that's what I call a speedy response! Many thanks for that. I didn't paste my attempt because it's already a lot more complicated than just the issue I posted, but I was already going down the wrong path in trying a SELECT in the FROM part. Here's that bit:
FROM products, (SELECT MIN(product_options.poPrice) AS fromprice FROM product_options WHERE product_options.poProductID = products.ProductID) AS priceoptions
I think I got it completely wrong! I'll try your suggestion now.
Originally Posted by MrFujin
Would be great if you had posted the SQL you tried.
General, you should be able to get the information with something like this: (untested)
SELECT p.ProductName , MIN(po.Price)
FROM Products p
INNER JOIN ProductOptions po ON p.pid = po.pid
WHERE p.ProductName = "Product 1"
GROUP BY p.ProductName