28,390
社区成员
发帖
与我相关
我的任务
分享access中两个表相关联进行数据更新的问题
有两个表daolu 和 daolu_info,这是我的更新语句
update daolu set daolu.ID=daolu_info.id from daolu,daolu_info where daolu.NAME = daolu_info.name
执行时出现如下错误:语法错误(操作符丢失)在查询表达式中 daolu_info.id from daolu
大家帮我看看是怎么回事?
update daolu set daolu.ID=daolu_info.id from daolu,daolu_info where daolu.NAME = daolu_info.name
执行时出现如下错误:语法错误(操作符丢失)在查询表达式中 daolu_info.id from daolu
大家帮我看看是怎么回事?
...全文
请发表友善的回复…
发表回复
minlove99 2004-09-17
- 打赏
- 举报
谢谢大家了,尤其感谢夏天,请大家以后继续支持我
bladeinside 2004-09-17
- 打赏
- 举报
update daolu, daolu_info set daolu.ID=daolu_info.id where daolu.NAME = daolu_info.name
bladeinside 2004-09-17
- 打赏
- 举报
在access里是没有from子句的
jacklinchen的方法也是不对的
jacklinchen的方法也是不对的
sunjiujiu 2004-09-17
- 打赏
- 举报
对，jacklinchen的方法是正确无误的做法！
minlove99 2004-09-17
- 打赏
- 举报
还是不可以，错误提示为：
语法错误（操作符丢失）在查询表达式‘daolu_info.id
from daolu left join daolu_info on daolu.NAME=daolu_info.name'中
语法错误（操作符丢失）在查询表达式‘daolu_info.id
from daolu left join daolu_info on daolu.NAME=daolu_info.name'中
jacklinchen 2004-09-17
- 打赏
- 举报
update daolu set daolu.ID=daolu_info.id
from daolu Left join daolu_info on daolu.NAME = daolu_info.name
from daolu Left join daolu_info on daolu.NAME = daolu_info.name
99percent 2004-09-17
- 打赏
- 举报
最好能用它本身自带的属性来链接.
