Join multiple tables with active records

by

You can do the following:

Inscription.includes(item1: { item2: :banner })

The relations names item1, item2 and banner need to match the names given to each relation.

If you want to set a where statement on this query, you can do:

scope = Inscription.includes(item1: { item2: :banner }) 
scope = scope.where(banner: { name: "MOTD: Hello World!" })
scope = scope.where(item2: { is_favorite: true })

Similar questions:

More Related Contents:

  1. ActiveRecord Arel OR condition
  2. PostgreSQL where all in array
  3. Rails 4 LIKE query – ActiveRecord adds quotes
  4. Find all records which have a count of an association greater than zero
  5. Rails find record with zero has_many records associated [duplicate]
  6. ActiveRecord find_each combined with limit and order
  7. Rails raw SQL example
  8. How to use ANY instead of IN in a WHERE clause?
  9. PostgreSQL GROUP BY different from MySQL?
  10. MySQL not using indexes with WHERE IN clause?
  11. Best way to count rows by arbitrary time intervals
  12. Disable Rails SQL logging in console
  13. LEFT OUTER JOIN in Rails 4
  14. Rails 3 execute custom sql query without a model
  15. Perform this hours of operation query in PostgreSQL
  16. SQL where joined set must contain all values but may contain more
  17. Find records where join doesn’t exist
  18. Prepared Statement on Postgresql in Rails
  19. Only inserting a row if it’s not already there
  20. Stored Procedure with optional “WHERE” parameters
  21. subquery in FROM must have an alias
  22. SQL Between clause with strings columns
  23. Why can’t I use column aliases in the next SELECT expression?
  24. SQL not displaying null values on a not equals query?
  25. Can SQL Server Express LocalDB be connected to remotely?
  26. SQL LIKE condition to check for integer?
  27. Why don’t DBMS’s support ASSERTION
  28. move cells left in sql if left contains null and right contains value
  29. How to detect query which holds the lock in Postgres?
  30. Get the first and last date of next month in MySQL

Leave a Comment