SQL & PL/SQL

Can someone help me on this .

let me explain the problem ....
for eg
parts table is as

part_id volume sale_id shipid suplr method
1 100 111 *** 16 16
2 200 111 *** 16 16
3 50 222 *** 17 17
4 25 222 *** 17 17

now i get the total volume group by the sale_id ie
select sum(volume),sale_id group by sale_id.
and insert into ship table ...

ship table
shipid total_volume sale_id
1221 300 111
1222 75 222

Now my requirement is to get the ship_id for the parts and thus update the part table .

so that

part_id volume sale_id shipid
1 100 111 1221
2 200 111 1221
3 50 222 1222
4 25 222 1222
How can i do that ??

---
shubh

Message was edited by:
SHUBH

Message was edited by:
SHUBH

Message was edited by:
SHUBH