Bobochka
8/16/2015 - 6:10 PM

Doing "where in" in one query

Doing "where in" in one query

Instead of:

User.where(id: Contact.pluck(:user_id))

can do:

User.where(id: Contact.select(:user_id))
# User Load (1.6ms)  SELECT "users".* FROM "users"  WHERE "users"."id" IN (SELECT user_id FROM "contacts")
# => #<ActiveRecord::Relation [#<User...]>