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
(
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
(
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
注意单双引号.
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
注意单双引号.
(
select count(id) from a, b where b.ownum like '%'+mid(a.fnum,1,1)+'%' and b.ownum like '%'+mid(a.fnum,2,1)+'%'
)
where len(a.fnum)=2