Guest asherww11 Posted May 6, 2010 Share Posted May 6, 2010 help!!! everyone who knows the northwind database of access i have to select the category names and the most expensive products from each category(there are 8 kinds of categories)i have tried this:(but nothing)SELECT categories.CATEGORYNAME, productname,MAX (products.unitprice), DISTINCT( products.unitprice)FROM products, categoriesWHERE products.productid = categories.categoryidGROUP BY productname Link to comment Share on other sites More sharing options...
justsomeguy Posted May 10, 2010 Share Posted May 10, 2010 It sounds like you need to group by the category, not the product. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.