a simple sql question

i have a table looks like that:

  Store_id     Amt.
   D0            1000.00
    D1            500.00
    D2            400.00

Now i want to update that table, the Total Amt should minus 1300.00 My means is after update, the table should looks like:

  Store_id     Amt.
   D0               600 .00
    D1                0.00
    D2                0.00

(1000.00+500.00+400.00)-1300.00 =600.00 Is is possible use one sql to update?
tks for any suggestion. Received on Fri Dec 03 1999 - 02:18:25 CST