LEFT OUTER JOIN in Rails 4

by

You can pass a string that is the join-sql too. eg joins("LEFT JOIN StudentEnrollment se ON c.id = se.course_id")

Though I’d use rails-standard table naming for clarity:

joins("LEFT JOIN student_enrollments ON courses.id = student_enrollments.course_id")

More Related Contents:

  1. SQL where joined set must contain all values but may contain more
  2. Rails raw SQL example
  3. How to use ANY instead of IN in a WHERE clause?
  4. PostgreSQL GROUP BY different from MySQL?
  5. MySQL not using indexes with WHERE IN clause?
  6. Rails 4: List of available datatypes
  7. ActiveRecord OR query Hash notation
  8. Best way to count rows by arbitrary time intervals
  9. Disable Rails SQL logging in console
  10. ActiveRecord Arel OR condition
  11. Rails 3 execute custom sql query without a model
  12. Perform this hours of operation query in PostgreSQL
  13. Add a reference column migration in Rails 4
  14. Rails update_attributes without save?
  15. New data not persisting to Rails array column on Postgres
  16. Join multiple tables with active records
  17. PostgreSQL where all in array
  18. Find records where join doesn’t exist
  19. Rails 4 LIKE query – ActiveRecord adds quotes
  20. Find all records which have a count of an association greater than zero
  21. Rails find record with zero has_many records associated [duplicate]
  22. Prepared Statement on Postgresql in Rails
  23. Rails 4 – Gem::LoadError: Specified ‘mysql2’ for database adapter, but the gem is not loaded
  24. ActiveRecord find_each combined with limit and order
  25. Is ActiveRecord’s “order” method vulnerable to SQL injection?
  26. SQL to LINQ with multiple join, count and left join
  27. Oracle “(+)” Operator
  28. Safely rename tables using serial primary key columns
  29. Rails I18n validation deprecation warning
  30. Getting the Id of a row I updated in Sql Server

Leave a Comment