Linking records to a lookup table

[coopster]

I have a table of products which have related prices (the prices are linked by a lookup).

How can i construct a query that will pull my products while including the related prices (from the lookup which links to the size table) and then be able to sort by the min price for each?

I have my existing query if its of any help...

 

[r937]

yeah, it'll help

how many prices does each product have? and how many prices per product would you like in the query results?

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[coopster]

The products can have many prices, but on my listing screen i want to display the products by their min (grouped) price - while not showing all of them until the main display screen (once clicked thru).

 

[PHV]

A starting point:
SELECT A.name, Min(B.price)
FROM tblProducts A INNER JOIN tblPrices B
ON A.ID = B.productID
GROUP BY A.name

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244