更新表字段为另一张表的字段
update std_mendian_advert
set dept_id = sys_employee.dept_id
from sys_employee
where std_mendian_advert.creator_id = sys_employee.id
更新表字段为另一张表的字段
update std_mendian_advert
set dept_id = sys_employee.dept_id
from sys_employee
where std_mendian_advert.creator_id = sys_employee.id