Subqueries in activerecord

by

Rails now does this by default 🙂

Message.where(user_id: Profile.select("user_id").where(gender: 'm'))

will produce the following SQL

SELECT "messages".* FROM "messages" WHERE "messages"."user_id" IN (SELECT user_id FROM "profiles" WHERE "profiles"."gender" = 'm')

(the version number that “now” refers to is most likely 3.2)

More Related Contents:

  1. ExecJS and could not find a JavaScript runtime
  2. Rails 3.1 asset precompilation – include all javascript files
  3. Remove duplicate rows in MySQL
  4. Join vs. sub-query
  5. What is the error “Every derived table must have its own alias” in MySQL?
  6. Want to find records with no associated records in Rails
  7. JPA 2.0, Criteria API, Subqueries, In Expressions
  8. How to do this in Laravel, subquery where in
  9. Get records with highest/smallest per group
  10. Rails – Could not find a JavaScript runtime?
  11. MySQL DELETE FROM with subquery as condition
  12. CROSS/OUTER APPLY in MySQL
  13. Difference between CTE and SubQuery?
  14. Rails 3.1 asset pipeline: how to load controller-specific scripts?
  15. updating table rows in postgres using subquery
  16. Does SparkSQL support subquery?
  17. Multiple CTE in single query
  18. Return pre-UPDATE column values using SQL only
  19. ActiveRecord Arel OR condition
  20. MySQL/MariaDB – order by inside subquery
  21. How to delete from select in MySQL?
  22. Quick Explanation of SUBQUERY in NSPredicate Expression
  23. Can we call a Controller’s method from a view (as we call from helper ideally)?
  24. How to alias a field or column in MySQL?
  25. Rails naming convention for join table
  26. Postgres Error: More than one row returned by a subquery used as an expression
  27. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  28. Rails: FATAL – Peer authentication failed for user (PG::Error)
  29. Changing a column type to longer strings in rails
  30. How to make Devise redirect after confirmation

Leave a Comment