BTW I am trying something like
UPDATE "A" INNER
JOIN "B"
ON "A"."ACCOUNT_ID" = "B"."ACCOUNT_ID"
SET
"A"."CURRENT_BALANCE" = "A"."CURRENT_BALANCE"+
"B"."ACCOUNT_ID";
but it is not working
I have not done SQL
by hand since sometime in 2005/2006 and I can not remember how to do a
dynamic update using more then one table.
Let us say I have a
table A and a table B and I want to update a record in table A for every
record in table b base on information in table B. For example, let us say
I want A.CURRENT_BALANCE to be set to A.CURRENT_BALANCE + B.DEPOSIT where
A.ACCOUNT_ID = B.ACCOUNT_ID.
Thoughts?