Need help with SQL statement!
From: Alex <sh2222_at_yahoo.com>
Date: Tue, 29 Jul 2003 02:37:46 GMT
Message-ID: <_5lVa.117527$TJ.6968703_at_twister.austin.rr.com>
I am having difficulty writing a SQL statement and I was wondering if one of you gurus could help me. I have a table that has three fields: InvoiceID, Item, ItemPrice. Each InvoiceID is associated with one or more Items. I am trying to write a SQL statement that returns the record (all three fields) for the least expensive item for each invoice (so the total number of records returned will be equal to the total number of unique Invoice IDs. How would I write this SQL statement?
Date: Tue, 29 Jul 2003 02:37:46 GMT
Message-ID: <_5lVa.117527$TJ.6968703_at_twister.austin.rr.com>
I am having difficulty writing a SQL statement and I was wondering if one of you gurus could help me. I have a table that has three fields: InvoiceID, Item, ItemPrice. Each InvoiceID is associated with one or more Items. I am trying to write a SQL statement that returns the record (all three fields) for the least expensive item for each invoice (so the total number of records returned will be equal to the total number of unique Invoice IDs. How would I write this SQL statement?
Thank you,
Alex Received on Tue Jul 29 2003 - 04:37:46 CEST