query to update running balance without select query

[cerluca]

My Query Here\[code\]UPDATE TBLBANKTRANSACTION SET SU_CASHBALANCE = (SELECT SU_CASHBALANCE FROM TBLBANKTRANSACTION WHERE TBLBANKTRANSACTION.ID=1)-2000.0\[/code\]Can we update the balance without select query? or what is the simplest / better / fastest way to update running balance