下面的sql
错在哪里
strdel="DELETE [fileuserinf] where id not in ('select min(id) from [fileuserinf] group by reid ') and reid in ('select min(id) from [fileuserinf] where reid="'&aid&'" group by reid ')"
conn.execute(strdel)想通过这种方式删除指定reid值的重复数据?
错在哪里
strdel="DELETE [fileuserinf] where id not in ('select min(id) from [fileuserinf] group by reid ') and reid in ('select min(id) from [fileuserinf] where reid="'&aid&'" group by reid ')"
conn.execute(strdel)想通过这种方式删除指定reid值的重复数据?
conn.execute(strdel)in()和not in()括号里面的单引号去掉。
数据库连接状态:1
错误信息:语法错误 (操作符丢失) 在查询表达式 '[fileuserinf] where id not in (select min(id) from fileuserinf group by reid ) and reid in (select min(id) from fileuserinf where reid='2' group by reid )' 中。
出错对象: Microsoft JET Database Engine
记录集连接状态:1
response.end把SQL语句这样打出来看看,错在哪里。
试试这样子
strdel="DELETE [fileuserinf] where id not in (select min(id) from [fileuserinf] group by reid) and reid in (select min(id) from [fileuserinf] where reid="&aid&" group by reid)"
conn.execute(strdel)
conn.execute(strdel)