-
Newbie question - Trouble grouping data
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|