3075 - Syntax Error (missing operator)

[Guest]

The following SQL statement is triggering this error. Can anyone correct it?

UPDATE StaffWithMonthRecs INNER JOIN Timesheet ON StaffWithMonthRecs.StaffID
= Timesheet.StaffID INNER JOIN TimeSheetDetail ON Timesheet.TimesheetID =
TimeSheetDetail.TimesheetID SET TimeSheetDetail.Status1= 2 WHERE
TimeSheetDetail.DayHours1<>0 AND TimeSheetDetail.Status1=1;

Thank you.
Sprinks

 

[neonx3]

I believe the order of the statement has to be changed to this:

UPDATE StaffWithMonthRecs INNER JOIN
(Timesheet INNER JOIN TimeSheetDetail ON Timesheet.TimesheetID =
TimeSheetDetail.TimesheetID)
ON StaffWithMonthRecs.StaffID = Timesheet.StaffID
SET TimeSheetDetail.Status1= 2 WHERE TimeSheetDetail.DayHours1<>0 AND
TimeSheetDetail.Status1=1;

HTH,
Danny

 

[Guest]

Thank you, Neon. Exactly right.

Sprinks

I believe the order of the statement has to be changed to this:

UPDATE StaffWithMonthRecs INNER JOIN
(Timesheet INNER JOIN TimeSheetDetail ON Timesheet.TimesheetID =
TimeSheetDetail.TimesheetID)
ON StaffWithMonthRecs.StaffID = Timesheet.StaffID
SET TimeSheetDetail.Status1= 2 WHERE TimeSheetDetail.DayHours1<>0 AND
TimeSheetDetail.Status1=1;

HTH,
Danny