SQL Help - update query with two tables

[Bryan O'Neal]

I can not get this to work either, I get the following

>[Error] Script lines: 1-1 --------------------------
 DB2 SQL error: SQLCODE: -811, SQLSTATE: 21000, SQLERRMC: null
 Message: The result of a scalar fullselect, SELECT INTO statement, or
VALUES INTO statement is more than one row. 

-----Original Message-----
From: plug-discuss-bounces at lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces at lists.plug.phoenix.az.us] On Behalf Of
Joseph Sinclair
Sent: Friday, May 23, 2008 7:21 PM
To: Main PLUG discussion list
Subject: Re: SQL Help - update query with two tables

Sorry, hit send before rewriting to match your query:
UPDATE A Set (CURRENT_BALANCE) = (SELECT A.CURRENT_BALANCE + B.DEPOSIT