三个表Join的Update语句总是报错

Jack　发表于：2014-09-04 05:43:53 　

Update (tabBonusMonthly As B Inner Join tabEmpInfo As E On B.EmpID = E.EmpID and E.PositionID = 4) Inner Join tabBonusMonthly_Temp As T On B.EmpID = CLng(T.F2) and (B.BDate = CDate(T.F1)) Set B.Comments = CStr(B.Adjusted), B.Adjusted = 0

提示不支持Join表达式，请给看看问题在哪儿，谢谢！

Top

在水一方发表于：2014-09-04 10:05:29

Update (tabBonusMonthly As B Inner Join tabEmpInfo As E On B.EmpID = E.EmpID ) Inner Join tabBonusMonthly_Temp As T On B.EmpID = CLng(T.F2) and (B.BDate = CDate(T.F1)) Set B.Comments = CStr(B.Adjusted), B.Adjusted = 0 where E.PositionID = 4;

Top

煮江品茶发表于：2014-09-04 17:43:38

联接没球意义，更新的字段与更新的值都只是涉及一个表。

Update tabBonusMonthly Set Comments = CStr(Adjusted), Adjusted = 0
where EmpID in (select EmpID from tabEmpInfo where PositionID = 4)

Top

总记录：2篇页次：1/1 9 1 :

Access交流中心

三个表Join的Update语句总是报错