两个表结构相同，更新其中一个表不全的情况下

[sql]代码库

update ext_testuser set ext_testuser.email = ext_smauser.email,
ext_testuser.cellphone = ext_smauser.cellphone,
ext_testuser.userid = ext_smauser.userid,
ext_testuser.loginname = ext_smauser.loginname
 from ext_testuser left join ext_smauser on ext_smauser.idcard = ext_testuser.idcard

[代码运行效果截图]