Rails SQL查询与find

select id,name from questions
where id not in (select question_id from levels_questions where level_id=15)

我该怎么做？我正在使用Rails框架和MySQL.
提前致谢.

解决方法

ids = LevelsQuestion.all(:select => "question_id",:conditions => "level_id = 15").collect(&:question_id)
Question.all(:select => "id,name",:conditions => ["id not in (?)",ids])

一枪：

Question.all(:select => "id,:conditions => ["id not in (select question_id from levels_questions where level_id=15)"])

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!