Thanks both of you. I'll play around with it.

Rick

Thanks for hanging on. I'm trying to update two different (related) rows in a single table, MasterLoandata, each update row referenced as alias M1 and alias M2. The two related...

Let's back up a second then. I want to translate the SELECT shown above to an UPDATE statement. I want to update m1 balanceOutstanding  expressed as:

-- add +value...