get sum from update into temp table????

how do i get the sum of the qty item for a particular item. For example I am trying to get a total for the amount cancelled on a particular item. So say if they order 50 and they cancel 49. I want to get 49 back as a sum for each item?????? going into a temp table???



UPDATE wd
set wd.qty_cancelled = l.qty
from #workingdata wd
INNER join lala l
ON wd.item= l.item
WHERE l.status = 'cancelled'

Ah, too other DB on the brain, disregard my last...

[Edited by Mongo on 06-14-2000 at 09:21 PM]

with SQL 7/northwind DB

select Sum(OrderID) as sumOfOrderID into WD1 from Orders where orderid between 10248 and 10275 (and other criteria here)

This will create the table named WD1 for your use for whatever

could you do an example of this using an ansi join that would be great thanks,



[Edited by Bebe on 06-14-2000 at 11:53 PM]

what are your table structures? I could do an example that might help, but I'd rather do one that will