SQL执行错误,请大虾们帮看看 在下先谢过了
update (select c.cdept_id as a,
d.strDepartmentCode as b
from VoucherDetail as c
left join Department as d
on d.lngDepartmentID=c.lngDepartmentID) as f set f.a=f.b
消息 102,级别 15,状态 1,第 1 行
'(' 附近有语法错误。
消息 156,级别 15,状态 1,第 5 行
关键字 'as' 附近有语法错误。