2010-04-12 mssql sql
mssql
UPDATE Table1 Set Field1 = Value FROM Table1 as t1 INNER JOIN Table2 as t2 on t1.Field2 = t2.Field2 WHERE Field3 = Value