用B表中栏位更新A表中的栏位信息

UPDATE R_COMBUS_BUSAPPLY SET org_id= B.org_id
FROM (SELECT org_id,emp_no FROM emp_data) AS B
INNER JOIN R_COMBUS_BUSAPPLY ON B.emp_no= R_COMBUS_BUSAPPLY.emp_no