Update table A for every instance in table B 1

[southbeach]

I have learned how to select records from two tables but now, I need to update every record in table A based on keys found in table B.

I have a KEY which I can match to records in table B and table B has a field which I can match to records in table A. I need to update table A and possibly table B.

How do I go about this?

Thanks,

 

[r937]

use the joined update syntax as described in the documentation for the UPDATE statement

r937.com | rudy.ca

 

[southbeach]

Thanks ... the manual helped!