[dba-SQLServer] sorry, let me try again

UPDATE AuthorsPublicationsmm 
INNER JOIN Authors 
ON AuthorsPublicationsmm.AuthorIDFK = Authors.AuthorID 
SET AuthorsPublicationsmm.AuthorIDGUIDFK = [Authors].[AuthorIDGUID]
WHERE (([Authors].[AuthorID]=[AuthorsPublicationsmm].[AuthorIDFK]));
 
Sent the wrong statement, but same problem. 
 
Susan H.