subtraction/addition when updating record thru sql
i have a field, "inventory" with X number. when i go to update the record, in my update statment, is it possible or how would i do:<BR><BR>UPDATE tableThis set inventory = (the current value) plus/minus the new value <BR><BR>
sorry. yes i would use the where clause to update just that one record. <BR><BR>UPDATE tblThis set the inventory = inventory + thevalue WHERE ID = 1<BR><BR>i have been doing is running a select statement to retrieve the value in field "inventory" and then using that plus the new value to then update the record. due to my limited knowledge, i was wondering if it's possible do to it in one shot.