INSERT INTO SELECT问题？
table1，table2,tabel3都有身份证字段sfzh，
我想tabel1在tabel3中没有的数据sfzh都插入table2中，用INSERT INTO SELECT能解决吗，怎样写
------解决方案--------------------
- SQL code
insert into table2(sfzh) select sfzh from tabel1 where sfzh not in (select sfzh from tabel3)