Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ligthausdigital

    SQL Query Help - Multiple Grouping Columns

    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...
  2. ligthausdigital

    SQL Query Help

    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
  3. ligthausdigital

    SQL Query Help - Multiple Grouping Columns

    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...
  4. ligthausdigital

    SQL Query Help

    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...

Part and Inventory Search

Back
Top