帮我看看这个简单的SQL语句错在哪里。(100分)

D

dbgg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-09

• #1

access数据库

update a set icount=
(
select count(id) from b where b.ownum like '%'+mid(a.fnum,1,1)+'%' and b.ownum like '%'+mid(a.fnum,2,1)+'%'
)
where len(a.fnum)=2

 

D

dey-999

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-09

• #2

update a set icount=
(
select count(id) from b where b.ownum like ''%'+mid(a.fnum,1,1)+'%'' and b.ownum like ''%'+mid(a.fnum,2,1)+'%''
)
where len(a.fnum)=2

 

D

dbgg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-09

• #3

你这也不行啊，更是报错。

 

D

dbgg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-09

• #4

或者如果能解决下面的sql语句也行。
UPDATE a SET a.iCount = (select count(*) from b)
就这么一个语句，它报错：操作必须使用一个可更新的查询

 

Z

ztao1979

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-09

• #5

update a set icount=
(select count(id) from b where b.ownum like ''%'+mid(a.fnum,1,2)+'%'' )
where len(a.fnum)=2

 

网

网中戏

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-11

• #6

顶

 

H

hityou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-09-11

• #7

UPDATE a SET a.iCount = (select count(*) from b)

update a,(select count(*) as nn from b) C set A.icount=B.nn