SQL Syntax Error ?

[bigstav]

Hi , i'm trying to execute the following ...

DoCmd.RunSQL "UPDATE tbl_Sites RIGHT JOIN (qry_ExportCARLock_DCDA INNER JOIN tbl_MPANs ON qry_ExportCARLock_DCDA.MPANCore = tbl_MPANs.MPANCore) ON tbl_Sites.SiteRef = tbl_MPANs.SiteRef SET [tbl_Sites].[CALock_DCDA] = Now();"

and am getting the error ...

"The specified Field 'tbl_Sites.CALock_DCDA' could refer to more than one table listed in the FROM caluse of your SQL statement"

can anyone suggest a better syntax for my SQL please ?.
Thanks, Mark.