我真的是个sql语句盲,
我想把edepartGeneral的username和department设置成userinfo中的username和department,edepartGeneral中的operator和userinfo中的name是对应的.
我查询时是正确的,语句如下
select a.username,a.department from edepartGeneral as a join userinfo as b on b.name=a.operator但是我update就出错,我不知道为什么,语句如下
update edepartGeneral as a set a.username=b.username,a.department=b.department join userinfo as b on b.name=a.operator
我想把edepartGeneral的username和department设置成userinfo中的username和department,edepartGeneral中的operator和userinfo中的name是对应的.
我查询时是正确的,语句如下
select a.username,a.department from edepartGeneral as a join userinfo as b on b.name=a.operator但是我update就出错,我不知道为什么,语句如下
update edepartGeneral as a set a.username=b.username,a.department=b.department join userinfo as b on b.name=a.operator
set a.username=b.username,a.department=b.department
update edepartGeneral as a set a.username=b.username,a.department=b.department from userinfo as b where a.operator=b.name
from edepartGeneral as as a
inner join userinfo as b on a.operator=b.[name]