Clinton Posted October 15, 2007 Share Posted October 15, 2007 I've got a master inventory list that includes the Item Description, it's location, and quantity. If I have duck tape in 3 places it will show: Duck Tape - Office - 2 Duck Tape - Shop - 27 Duck Tape - Trailer - 1 Can I combine all the duck tapes (and there are other multiples in this list that would need to be combined as well) it so the master list says: Duck Tape - 30 Etc... ???? Quote Link to comment Share on other sites More sharing options...
simcoweb Posted October 15, 2007 Share Posted October 15, 2007 So you want it to just display ALL instances of Duct Tape as one item in a list? Quote Link to comment Share on other sites More sharing options...
Clinton Posted October 15, 2007 Author Share Posted October 15, 2007 Correct Quote Link to comment Share on other sites More sharing options...
Barand Posted October 15, 2007 Share Posted October 15, 2007 SELECT product, SUM(qty) as total FROM inventory GROUP BY product Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.