[dba-SQLServer] UPDATE syntax with JOIN

UPDATE Authors 
INNER JOIN AuthorsPublicationsmm 
ON Authors.AuthorID = AuthorsPublicationsmm.AuthorIDFK 
SET AuthorsPublicationsmm.AuthorIDGUIDFK = [Authors].[AuthorIDGUID]
WHERE (([Authors].[AuthorID]=[AuthorsPublicationsmm].[AuthorIDFK]))
 
======The above statement runs in Access just fine, but I get an error on
INNER JOIN in SQL Server. I checked bol, but geez... what a mess that was.
:( 
 
I'm trying to update the AuthorIDGUIDFK value in a many to many table based
on the AUthorIDGUID value in Authors.
 
Thanks!
Susan H.