SQL 高手请进
INSERT INTO awardnew2(customerid,name,sex,age,job,mobile,address)
SELECT customerid,user_name,sex,age,job,mobile,address FROM SurveySelphy
where customerid not in (select customerid from awardnew2)
由于表awardnew2中的customerid是主键, 但是 SurveySelphy表中的customerid的值是有重复,请问我怎么将这些数据导入到awardnew2中 ?