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!
-
Congratulations gkittelson 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: *
- Users: JJDILLONUSA
- Order by date
-
How do I get one row from many like rows plus sum quantities.
Thank you for you response and yes Bill should have 3 boards :) I do have one more related question however. The example I gave was hypothetical and perhaps too simplistic. I real life I would also like to include other fields that would not be part of the group by. Customer Address for...- JJDILLONUSA
- Post #3
- Forum: ANSI_SQL
-
How do I get one row from many like rows plus sum quantities.
In SQL is there a way I can get a listing like this Cust Item Qty BILL Nails 6 BILL Board 2 RICK Gum 1 from a table containing this? BILL Nails 2 BILL Board 1 BILL Nails 4 BIll Board 2 RICK GUM 1 Sorry if this is a real newbie question.- JJDILLONUSA
- Thread
- Replies: 3
- Forum: ANSI_SQL
