开发者

sqlite 3.5.9 problem

I have query

SELECT c.*, sum(cnt.count) AS Questions FROM chapters c 
JOIN( SELECT q.chapterid, count(q.chapterid) AS count, t.LinkChapter 
FROM questions q 
JOIN( SELECT DISTINCT questionid, LinkChapter FROM questionstests 
WHERE testid = '"+ testID +"' )t开发者_JAVA技巧 ON t.questionid = q.questionid 
GROUP BY q.chapterid,t.LinkChapter )cnt 
ON cnt.chapterid = c.chapterid OR cnt.LinkChapter = c.ChapterID 
GROUP BY c.ChapterID ORDER BY SortBy

that perfectly worked on sqlite 3.6.22 but throw 'Could not build iterator' exception on sqlite 3.5.9. Can anyone help me with this problem?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜