I run this in SQL Server to do an aggregate in an update query
However, when I paste this into SQL View in acccess I get the errorCode:update HCL set masterAchieved = 'Yes' from HCL where gamertag in (select gamertag from HCL where medalsleft = 0)
Syntax error - missing operator in query expression 'Yes' from HCL
How should this be altered to run in Access 2013?