Search results for query: *

Thank you! I can't use that exactly, but it got me to where I needed to be. It's in Access, so I tried doing what your statement said from the GUI. Here's the result if your curious. And thanks again, I truly appreciate it. SELECT pricesearch.isbn, pricesearch.minprice, books.pkey FROM...

Thanks, but maybe I didn't make it clear. Even books with the same ISBN have different SKUs. When I add sku to the GROUP BY clause, it ends up showing every book, just sorted differently. I need to show only one book per ISBN. Thanks, Morgan

Hello, Here's what I'm trying to do: For each ISBN number in a catalog of used books, I need to find the lowest price book, and return the SKU and the price. Right now I can only get the price out. My query looks like this: SELECT isbn, min(price) as minprice FROM books GROUP BY isbn; The...

Hello, Here's what I'm trying to do: For each ISBN number in a catalog of used books, I need to find the lowest price book, and return the SKU and the price. Right now I can only get the price out. My query looks like this: SELECT isbn, min(price) as minprice FROM books GROUP BY isbn; The...