Update Table1  A Set  Field1 = ‘Value’

Where exists(Select * from Table2 B where A.ID = B.ID)