?
1.同时更新2个字段:update 帐号表2 set [email protected],DeptName=(select DeptName from 部门表 where [email protected])