更新T_STAFF 表中的DEPARTMENT字段,
DEPARTMENT字段与表T_NominationSTAFF 中的T_NominationSTAFF 对应
update T set DEPARTMENT=(select DEPARTMENT from T_NominationSTAFF where e_mail=T.e_mail)
from T_STAFF T
更新T_STAFF 表中的DEPARTMENT字段,
DEPARTMENT字段与表T_NominationSTAFF 中的T_NominationSTAFF 对应
update T set DEPARTMENT=(select DEPARTMENT from T_NominationSTAFF where e_mail=T.e_mail)
from T_STAFF T