In Rails 3 how to query across a has one assositation?

Question

In rails 3, I have accounts and users, it looks like this:

class Account < ActiveRecord::Base
  has_one :owner, :class_name => "User", :dependent => :destroy
end

I have something like this but it doesn't work, I want to join on the owner association and order and what not by it:

Account.includes(:owner).where(["owner.email = ?", "[email protected]"])

What's the correct way of going about this? Thanks.

Answer 1

Account.includes(:owner).where("users.email=?", "[email protected]")

The condition should use the table_name

Answer 2

The right thing would be to do like this:-

Account.joins(:owner).where(["owner.email = ?", "[email protected]"]).includes(:owner)