string MyInsert = "insert into QQ1 select name from QQ2 not in ( select name from QQ1)";


报错："关键字 'not' 附近有语法错误。"

这句代码有错误吗，还是别的原因？

改成这样了，还是不行，还是把全码发上来，帮我诊断下吧

string constring = "server=192.168.1.11;database=daofeng;uid=DF;pwd=DAOFENG";
SqlConnection MyConnection = new SqlConnection(constring);
MyConnection.Open();
string MyInsert = "insert into QQ1 select name from QQ2 a where not exists ( select name from QQ1 b where a.name=b.name) ";
SqlCommand MyCommand = new SqlCommand(MyInsert, MyConnection);

MyCommand.ExecuteNonQuery();

MyConnection.Close();