sSql="select StuInfo.StuName,CourseSelectedInfo.* from CourseSelectedInfo Left Join StuInfo ON StuInfo.StuID= CourseSelectedInfo.StuID where StuID in (select StuID from CourseSelectedInfo where CID='"&course&"')"
运行时.IE提示StuID不明确.该什么修改.

sSql="select StuInfo.StuName,CourseSelectedInfo.* from CourseSelectedInfo Left Join StuInfo ON StuInfo.StuID= CourseSelectedInfo.StuID where StuInfo.StuID in (select StuID from CourseSelectedInfo where CID='"&course&"')"
这样试下

楼上的对