Subquery returns more than 1 row 表示子查询返回了多行数据
1、今天做ITOO出现了这个问题
2、MYSQL 代码:
string sql = @"select DictionaryName,Id from t_systemdictionary where id in(
select questiontypeid from t_examtemplatedetails where templateid in ( select other1 from t_examdetails where ExamID=any(
select ExamID from t_exammain where CourseID=@CourseID
)))";
3、解决办法:
4、解决后显示的效果: