Update Joined Tables

[onbeat69]

i have two tables, i want to update table1(5 fields, i.e. A , B, C, D, E) with table 2(two fields, ie F, G) values.
Update (A,C) values in table 1 with (F, G) in table 2. based on A=F, update C value with G value. Assume there are 5 rows. How do you set-up update statement.

[TTT]

make two queries. loop select statement and update inside loop