求助access中的sql语句?

[hqh_hpu]

我写了这样的一条语句:
update ZhongXin_SP_Line a set a.终点埋深=b.起点埋深,a.终点X=b.起点X,a.终点Y=b.起点Y inner join temp b on a.终点=b.终点

它提示错误:

语法错误(操作符丢失)在查询表达式'b.起点Y inner join temp b on a.终点=b.终点'中.

有哪位大哥可以帮忙解决一下,小弟万分感谢

[OracleRoob]

update ZhongXin_SP_Line as a inner join [temp] as b on a.终点=b.终点 set a.终点埋深=b.起点埋深,a.终点X=b.起点X,a.终点Y=b.起点Y

[wwwwb]

update ZhongXin_SP_Line a
inner join temp b on a.终点=b.终点
set a.终点埋深=b.起点埋深,a.终点X=b.起点X,a.终点Y=b.起点Y

[wwwwb]

update ZhongXin_SP_Line a
inner join [temp] b on a.终点=b.终点
set a.终点埋深=b.起点埋深,a.终点X=b.起点X,a.终点Y=b.起点Y

[OracleRoob]

update ZhongXin_SP_Line as a
inner join [temp] as b on a.终点=b.终点
set a.终点埋深=b.起点埋深,a.终点X=b.起点X,a.终点Y=b.起点Y

[sylei121]

update ZhongXin_SP_Line a inner join temp b on a.终点=b.终点
set a.终点埋深=b.起点埋深,a.终点X=b.起点X,a.终点Y=b.起点Y