有三个表
Mark
markid | recorderID | tatalScore
1 319 10
2 320 30
Recorder
testID | recorderID | userID
5 319 aa
6 320 bb
Test
testID | testName
5 数学
6 英语
我的Repeater中的查询本来是SELECT Place=(SELECT COUNT(DISTINCT totalScore) FROM Mark WHERE a.totalScore >= a.totalScore),b.userID, a.totalScore FROM Mark AS a INNER JOIN Recorder AS b ON a.recorderID = b.recorderID ORDER BY Place
DropDownLis中是数学，英语之类的集合
当我想更新Repeater时，将查询改为
SELECT Place=(SELECT COUNT(DISTINCT totalScore) FROM Mark WHERE a.totalScore >= a.totalScore),b.userID, a.totalScore FROM Mark AS a INNER JOIN Recorder AS b ON a.recorderID = b.recorderID
where b.testID=(select testID from T_Test where testName="+ DropDownList1.SelectedValue+")
ORDER BY Place
为什么无法查询出来？