“Insert fld1,fld2,fld3 into table2 Select fld1,fld2,fld3 from table1 where fld1 not in select fld2 from table2”试试
好象语法是错了,你去看语法书 "Insert into UserTable (UserName,UserPwd) Values (@'sdf',@'adfasdf')";
sql="insert into table2 select 插入内容 from table1 where fld1 not in select fld2 from table2" (把table1表的记录添加到table2表) sql="insert into 目标数据表 select * from 源数据表" (把源数据表的记录添加到目标数据表)
"Insert into UserTable (UserName,UserPwd) Values (@'sdf',@'adfasdf')";
sql="insert into 目标数据表 select * from 源数据表" (把源数据表的记录添加到目标数据表)