UPDATE Table1 set Table1.USER_ID = B.MEM_ID from Table1 as A, Table2 as B where (A.field1 = B.field1)