请帮我看看这句话是哪里错了？

[tatty_bad]

Update [TableB] a inner join [TableC] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1 set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20

在查询分析器里面，提示是 a 附近有错误！

[wzy_love_sly]

Update a
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20
from 
[TableB] a 
inner join [TableC] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1 

[wgzaaa]

Update [TableB] set a17 = b.a17,a18 = b.a18,a19 = b.a19,a20 = b.a20
from [TableB] a inner join [TableC] b
on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1

[dawugui]

Update [TableB]
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20 
from [TableB] a inner join [TableC] b 
on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1 set a.a17 = b.a17,a.a18 = b.a18 and a.a19 = b.a19 and a.a20 = b.a20 

[-狙击手-]

Update  a  
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20 
from [TableB] a inner join [TableC] b 
on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1

[dawugui]

Update [TableB] 
set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20
from [TableB] a inner join [TableC] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1  

[sdlwhgw]

神龟复出了。。

[tatty_bad]

Update a set a.a17 = b.a17,a.a18 = b.a18,a.a19 = b.a19,a.a20 = b.a20 from [TableB] a inner join [Excel 8.0;DATABASE=C:\DD.MDB;HDR=YES;IMEX=1].[Sheet1$A7:BC100] b on a.a1 = b.a1 and a.a4 = b.a4 and a.a7 = b.a7 and a.a11 = b.a11 and b.AID = 1

数据库是Access的。

是在VBA里面执行的，提示操作符丢失。