how do I join and include the association
- by Mark
Hi All,
How do I use both include and join in a named scope?
Post is polymorphic
class Post
  has_many :approved_comments, :class_name => 'Comment' 
end
class Comment
  belongs_to :post
end
Comment.find(:all, :joins => :post, :conditions => 
                     ["post.approved = ? ", true],      :include => :post)
This does not work as joins does an inner join, and include does a left out join.
The database throws an error as both joins can't be there in same query.