UPDATE query with multiple INNER JOINs (syntax error) (1 Viewer)

I'm trying to run an update query with multiple join statements in VBA, but I keep getting "missing operator" errors. Same happens when I try to run the SQL in query builder. The SQL is:

Can anyone see what I'm doing wrong?

Try eliminating part of it by running
UPDATE TBL_DocReview_SingleStudy
INNER JOIN TBL_LOA
ON TBL_LOA.MemberName = TBL_DocReview_SingleStudy.Member
SET TBL_DocReview_SingleStudy.DateLOA2 = TBL_LOA.Status
in the query builder (after copying your db first - OF COURSE) and see if this query gives you the same problem.

Also try it as a SELECT query and see if it'll run.

see http://www.techonthenet.com/access/queries/update2.php
and http://www.w3schools.com/sql/sql_update.asp