INSERT INTO SELECT问题？INSERT INTO SELECT问题？table1，table2,tabel3都有身份证字段sfzh，我想tabel1在ta
INSERT INTO SELECT问题？
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)