I have a table with multiple rows per stock item indicating multiple
suppliers and the quantity they have instock like:

Stock_no supplier_id quantity
101221 100 5
101221 101 25
101221 105 33
101222 102 12
101222 103 15
101223 105 10
101223 100 23

and I want to run a query that sums all the quantities to one row per
stock item to upload to my webserver:

stock_no quantity
101221 63
101222 27
101223 23

Any help would be much appreciated.

Thanks in advance
Jonathan Kadish

kadish (AT) satelliterecords (DOT) com (Jonathan Kadish) writes:
This is basic SQL...

select stock_no, sum(quantity) as quantity from stock_table group by stock_no;
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','acm.org').
http://www.ntlug.org/~cbbrowne/rdbms.html
"A program invented (sic) by a Finnish computer hacker and handed out free
in 1991 cost investors in Microsoft $11 billion (#6.75 billion) this week."
-- Andrew Butcher in the UK's Sunday Times, Feb 20th, 1999