insert into Table2(field1,field2,field3,field4,field5)(select field1,field2,field3,field4,field5 from Table1 where field1 not in (select field1 from Table2) and field1 is not null and field<>‘‘)从Table1插记录到Table2，Field1不重复,布布扣,bubuko.com
从Table1插记录到Table2，Field1不重复
原文：http://blog.csdn.net/jcx5083761/article/details/22896435
