7,714
社区成员
发帖
与我相关
我的任务
分享请教关于Access 的SQL语句问题
update ans a set
mark=(select max(b.mark) as mark from score b
where b.id=1 and b.code0=2
and b.code1=0 and a.ord=b.ord and a.ans=b.ans
)
where no= 1
在Oracle可以执行，在Access 怎么执行不了呢
mark=(select max(b.mark) as mark from score b
where b.id=1 and b.code0=2
and b.code1=0 and a.ord=b.ord and a.ans=b.ans
)
where no= 1
在Oracle可以执行，在Access 怎么执行不了呢
...全文
请发表友善的回复…
发表回复
WWWWA 2011-09-19
- 打赏
- 举报
update ans a set
mark=dmax("mark","score","id=1 and code0=2 and code1=0 and ord=" & a.ord & "and ans=" & a.ans)
where [no]= 1
假设ord、ans为数字型
dawugui 2011-09-18
- 打赏
- 举报
update ans set
mark=(select max(b.mark) as mark from score b
where b.id=1 and b.code0=2
and b.code1=0 and a.ord=b.ord and a.ans=b.ans
)
from ans a
where no= 1
mark=(select max(b.mark) as mark from score b
where b.id=1 and b.code0=2
and b.code1=0 and a.ord=b.ord and a.ans=b.ans
)
from ans a
where no= 1
