在ACCESS里的UPDATE语句怎么写？我的语句有问题？

[bJiao]

update kjindex set kjindex.id1=kjmdmx.id2 from kjindex,kjmdmx where kjindex.mc=kjmdmx.mc
我这样写的语句在SQLSERVER 里是正确的，但在ACCESS里不能通过，请高手帮忙看一下！

[caihong]

应该是这样写的
update kjindex set kjindex.id1=kjmdmx.id2 from kjindex inner join kjmdmx where kjindex.mc=kjmdmx.mc

[_1_]

access中好象是：
update kjindex，kjmdmx set kjindex.id1=kjmdmx.id2 from where kjindex.mc=kjmdmx.mc

[dolphin11]

update kjindex,kjmdmx set kjindex.id1=kjmdmx.id2 where kjindex.mc=kjmdmx.mc

[yangp]

update kjindex set id1=a.id2 from kjmdmx a
where kjindex.mc=a.mc