为什么下面sql语句第一条可以,而第二条就不行insert into laowu1(id) SELECT ygid FROM gzjb IN [ODBC][ODBC;Driver=SQL Server;UID=sa;PWD=1121;Server=sw;DataBase=serv;]delete * from laowu1 where (laowu1.id not in (select id from laowu in [ODBC][ODBC;Driver=SQL Server;UID=sa;PWD=1121;Server=sw;DataBase=serv;]用ado连的access数据库.
delete from laowu1 where (laowu1.id not in (select id from laowu in [ODBC][ODBC;Driver=SQL Server;UID=sa;PWD=1121;Server=sw;DataBase=serv;])
如果你连的是SQL Server 把第二句改成下面的试试:
delete from laowu1 where laowu1.id not IN (select id from laowu in [ODBC][ODBC;Driver=SQL Server;UID=sa;PWD=1121;Server=sw;DataBase=serv;])