November 17th, 2012, 10:02 AM
|
|
Registered User
|
|
Join Date: Nov 2012
Posts: 2
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.
Thanks again.
Jon
Quote: | 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)
Code:
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
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
