我的问题是,我正在尝试编写一个SQL查询,它将选择所有问题及其答案,首先按Question.Sort排序,然后按QuestionsAnswers.Sort排序。我可以让Order By Questions.Sort正常工作,但是一旦我添加了第二个排序列,它就出错了。AS QAINNER JOIN ON QA.AnswerId = A.Id
ORDER
answers': [
'[{"_id": {"$oid": "5efba1c9a4bd7de54890a7ca"}, "answer": "This is a store house of all doubtsdifferent topic."}, {"_id": {"$oid": "5efba408402375df5fe9484b"}, "answer": "