VBA - 缺少运算符SQL查询错误

I'm trying to update the table with inner join using VBA in MS Access but I've tested the SQL I'm trying to update the table with inner join