Can't get UPDATE query to work with Join inside

[svcghost]

Hey guys,



I just can't get this query to work. I'm not sure what's wrong with it.

DoCmd.RunSQL ("UPDATE ec SET ObstructedView = EventPrep.Club_1_Check FROM " & vEventID & "_C ec 
INNER JOIN EventPrep ON ec.EventID = EventPrep.EventID WHERE ec.SubscriberType='Club' OR ec.SubscriberType='Bar';")

Any ideas?


The error I get is telling me: "Syntax error (missing operator) in query expression '54fdsf' FROM EUC0412_C ec INNER JOIN EventPrep ON EUC0412_C.EventID = EventPrep.EventID

[RuralGuy]

These action queries do not work if the record is ambiguous. Maybe this link can assist you: http://allenbrowne.com/ser-61.html

[svcghost]

I'm not quite sure how it is ambiguous. Is there any way I can clean up my query so it isn't unclear?

[weekend00]

try this update syntax:
update xxx inner join xxxx on xxxxx set x=y where......