As i mentioned in the comment to the question, your requirements are not clear. So, i can only suggest you sample solution.
An
update
statement might look like:
UPDATE t1 SET t1.Field1 = t2.Field2
FROM Table1 AS t1 INNER JOIN Table2 AS t2 ON t1.PK = t2.FK
where:
PK
- Primary Key
FK
= Foreign Key
Primary and Foreign Key Constraints[
^]
Change the code to your needs.
Next time, please be more specific and provide more details to be able to understand criteria to change data.