Home > Q&A > body text
模型:
1
2
3
4
5
class User < ActiveRecord::Base has_may :friends
class
User < ActiveRecord::Base has_may :friends
end
class Friend < ActiveRecord::Base
Friend < ActiveRecord::Base
belongs_to :user
数据库:查询:同时拥有:friends.name = "Lily" 以及 friends.name = "Steven"的User(本问题的结果应该可以查出User表的1和2)。我想通过模型查询来实现:User.joins(xxx).where(xxx)请问有这样的方法吗?
三叔2016-11-09 13:21:13
User.joins(:friends).where(friends: {name: "Lily"}) & User.joins(:friends).where(friends: {name: "Steven"})
User.joins(:friends).where(friends: {name:
"Lily"
}) & User.joins(:friends).where(friends: {name:
"Steven"
})