• UPDATE x SET x.b = y.d

    FROM TABLE1 x

    JOIN table2 y ON x.a = y.c