LEFT OUTER joins in Rails 3

ruby-on-rails ruby activerecord
Neil Middleton picture Neil Middleton · Jul 14, 2010 · Viewed 65.5k times · Source

I have the following code:

@posts = Post.joins(:user).joins(:blog).select

which is meant to find all posts and return them and the associated users and blogs. However, users are optional which means that the INNER JOIN that :joins generates is not returning lots of records.

How do I use this to generate a LEFT OUTER JOIN instead?

Answer

Neil Middleton picture Neil Middleton · Jul 14, 2010 
@posts = Post.joins("LEFT OUTER JOIN users ON users.id = posts.user_id").
              joins(:blog).select

Related questions

How to drop columns using Rails migration

What's the syntax for dropping a database table column through a Rails migration?

Read More
Rails Active Record find(:all, :order => ) issue

I seem to be unable to use the ActiveRecord::Base.find option :order for more than one column at a time. For example, I have a "Show" model with date and attending columns. If I run the following code: @shows = …

Read More
How to get last N records with activerecord?

With :limit in query, I will get first N records. What is the easiest way to get last N records?

Read More