string sql="select s.SubjectName from Subject as s inner join Course as c on(s.SubjectId=c.SubjectId) inner join Class as ca on(ca.ClassId=(select ca.ClassId from Class where ca.ClassName like '"+iClassName+"'))";
这句SQL有错误
改为:
string sql="select s.SubjectName from Subject as s inner join Course as c on s.SubjectId=c.SubjectId inner join Class as ca on c.ClassId = ca.ClassId where ca.ClassName like '"+iClassName+"'))";
试试
这句SQL有错误
改为:
string sql="select s.SubjectName from Subject as s inner join Course as c on s.SubjectId=c.SubjectId inner join Class as ca on c.ClassId = ca.ClassId where ca.ClassName like '"+iClassName+"'))";
试试
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货