Hi all,

I'm having a bit of a problem grouping data together. In a nutshell, i'm trying to extract information from two tables; a Products table and Merchant_Products table.

The Products table contains a single product and the Merchant_Product contains all linked products. I'm trying to pull out the lowest priced product from Merchant_Products but when i'm using the Group By command i get an error. I'm using the following query to extract the information:

SELECT Merchant_Products.Merchant_Product_Price, Products.Product_Name, Products.Product_Description, Products.Product_Image_URL,
Products.Product_ID, Category.Category_ID
FROM Merchant_Products INNER JOIN
Products ON Merchant_Products.Product_ID = Products.Product_ID INNER JOIN
Category ON Products.Cat_ID = Category.Category_ID
ORDER BY Products.Product_ID

Any help would be much appreciated as i'm truly stuck.

Cheers,

Sach