Update Query with multiple inner join

[phineas629]

Hi all,



I'm trying to update a table based on inner join of 3 related tables.

Thanks

UPDATE dbo_GRGrantNotes
 INNER JOIN dbo_GRConstituent_Recipient ON
dbo_GRGrantNotes.GrantId = dbo_GRConstituent_Recipient.GrantId
 INNER JOIN (dbo_GRGrants ON dbo_GRConstituent_Recipient
dbo_GRGrants.GrantId = dbo_GRConstituent_Recipient.GrantId)
SET NatureOfGrant =  "FBO " & dbo_GRConstituent_Recipient.FullName 
WHERE NatureofGrant is Null AND dbo_GRGrants.GrantType = S

[June7]

What is the issue, what happens - error message, wrong results, nothing?

I suspect need to put the S in quote marks.