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... ???? Link to comment https://forums.phpfreaks.com/topic/73369-combining-like-attributes/ 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? Link to comment https://forums.phpfreaks.com/topic/73369-combining-like-attributes/#findComment-370156 Share on other sites More sharing options...
Clinton Posted October 15, 2007 Author Share Posted October 15, 2007 Correct Link to comment https://forums.phpfreaks.com/topic/73369-combining-like-attributes/#findComment-370179 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 Link to comment https://forums.phpfreaks.com/topic/73369-combining-like-attributes/#findComment-370251 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.