在sql-server中用这种写法最直观:
UPDATE a
SET a.c = b.c
FROM table1 a
inner join table2 b on b.a=a.a
WHERE a.c is null
转载于:https://www.cnblogs.com/Impulse/p/4933696.html
在sql-server中用这种写法最直观:
UPDATE a
SET a.c = b.c
FROM table1 a
inner join table2 b on b.a=a.a
WHERE a.c is null
转载于:https://www.cnblogs.com/Impulse/p/4933696.html