//从表A中找出表B没有的数据插入表B string sqlstring="insert into B select * from A where A.ID not in (select ID from B)"