请问下面的SQL语句哪儿错了sql = "SELECT per_ID,per_Name,per_Iden,per_Sex,per_SPhone,per_MPhone,per_Email,DutyName,PostName FROM vwAllPerson WHERE (per_Name" +
"IN (SELECT per_Name FROM vwAllPerson WHERE per_Name=@word1))" +
" group by per_ID,per_Name,per_Iden,per_Sex,per_SPhone,per_MPhone,per_Email,DutyName,PostName";
"IN (SELECT per_Name FROM vwAllPerson WHERE per_Name=@word1))" +
" group by per_ID,per_Name,per_Iden,per_Sex,per_SPhone,per_MPhone,per_Email,DutyName,PostName";
这里per_Name这一句外不需要括号!~~~
还是报错:在关键字 'SELECT' 附近有语法错误。
第 1 行: ')' 附近有语法错误。
" IN (SELECT per_Name FROM vwAllPerson WHERE per_Name=@word1))" +
" group by per_ID,per_Name,per_Iden,per_Sex,per_SPhone,per_MPhone,per_Email,DutyName,PostName";
::IN前面缺少空格
sql = "SELECT per_ID,per_Name,per_Iden,per_Sex,per_SPhone,per_MPhone,per_Email,DutyName,PostName FROM vwAllPerson WHERE (per_Name" +
"IN (SELECT per_Name FROM vwAllPerson WHERE per_Name=@word1))" +
" group by per_ID,per_Name,per_Iden,per_Sex,per_SPhone,per_MPhone,per_Email,DutyName,PostName"; 少空格 你现在的是per_NameIN ()