• Could also be:

    UPDATE t1

    SET t1.[field2] = t2.[field2]

    FROM [table1] t1

    INNER JOIN [table2] t2 NO t1.[field1] = t2[field1]

    Eliminates the subquery. Should be more efficient on large datasets.