A，B表对比以后怎么把A表没有B表有的数据插入到A表中去

[0798]

conn.execute("insert into a (customer,address) values ('"&b.customer&"','"&b.address&"') from net a inner join net_xf b on b.customer not in (select customer from net)")
---------------------------------------------------------------------
上面是我写的， 可不知道为什么不能成功，麻烦哪为朋友帮助改一下

[sy_binbin]

查查insert into select 的写法

[egg_server]

....没看明白你写的
insert into a (customer,address) select customer,address from b where 你的条件

[gingerkang]

的确看不明白你写的语句
insert into net (customer,address) select customer,address from net_xf where customer not in (select customer from net)