need help with update sql

[BRADLEY21]

I am trying to update a field of table1 with a field from table2. something like this..

Update table2 set field1 with (field1 of table2) both tables have a common key to join

Any help would be appreciated

 

[MeanGreen]

Try this:

update table1
set col1 = table2.col1
from table1 join table2
on table1.keycol = table2.keycol

That should do it.

Good Luck.