UPDATE t1
SET t1.col2=t2.col2,
t1.col3=t2.col3
FROM t1
[INNER JOIN|LEFT JOIN] t2 ON t1.col1=t2.col1
WHERE .......
SQL
暂无评论
UPDATE t1
SET t1.col2=t2.col2,
t1.col3=t2.col3
FROM t1
[INNER JOIN|LEFT JOIN] t2 ON t1.col1=t2.col1
WHERE .......
SQL