开发者

sqlite 3.5.9 problem

开发者 https://www.devze.com 2023-03-12 22:16 出处:网络
I have query SELECT c.*, sum(cnt.count) AS Questions FROM chapters c JOIN( SELECT q.chapterid, count(q.chapterid) AS count, t.LinkChapter

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

精彩评论

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