A 表和B表有一列相同,根据B表相同的一列更新A表对应的列 delete table A update table A set column A=b.column A from table A a inner join table B b on a.column C =b.column C update table A set column B=b.column B from table A a inner join table B b on a.column C =b.column C update table A set column D =b.column D from table A a inner join table B b on a.column C =b.column C select * from dbo.table A order by column ID
|