SQL Help - update query with two tables

Top Page
Attachments:
Message as email
+ (text/plain)
+ (text/html)
+ (text/plain)
Delete this message
Reply to this message
Author: Bryan O'Neal
Date:  
To: Arizona State University Linux Users Group, Main PLUG discussion list
Subject: SQL Help - update query with two tables
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?
---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss