两表间拷贝数据

两张表是一样的，只是新老数据更新
update dbo.classmates
set LoginTimes = (select LoginTimes from dbo.classmates2 where classmates.id = classmates2.id )