1、多表语句更新
UPDATE
B
SET
B.loginname=c.loginname
FROM
t_employee A, t_systemuser B, oa_employee c
WHERE
A.employeeid=B.belonguserid
AND
A.oaemployeeid = c.id
1、多表语句更新
UPDATE
B
SET
B.loginname=c.loginname
FROM
t_employee A, t_systemuser B, oa_employee c
WHERE
A.employeeid=B.belonguserid
AND
A.oaemployeeid = c.id
转载于:https://www.cnblogs.com/gyjjyg/p/10615622.html