UPDATE SQL. How to update table 2 field1 with table1 field1

[pedie]

Hi, please help me with SQL on how to update table 2 field1 with table1 field1 , where table2 field2 = table1 field2 and i have multiple recs in both table.

Thanks.

 

[BrianMH]

Update table2 
inner join table1 on table1.field2 = table2.field2
set table2.field1 = table1.field1

 

[pedie]

thanks Brian works like charm.

 

[BrianMH]

Glad to help!