例如:
到帐记录表:B_Financial
员工表:B_Employees
现在情况:B_Financial新增字段DepartmentID,则需要把B_Employees的DepartmentID更新到表:B_Financial的DepartmentID字段中
update
B_Financial
set DepartmentID=a.DepartmentID
from
(SELECT B_Financial.EmployeeID,B_Employees.DepartmentID FROM
B_Financial LEFT OUTER JOIN
B_Employees on
B_Financial.EmployeeID = B_Employees.EmployeeID) a
where B_Financial.EmployeeID=a.EmployeeID