Rails: Limit SQL fields for included table > find(:include => {:select => "id,title"})

Question

I have 2 tables :products and :providers with has_and_belongs_to_many association.

I would like to do this

@list = Product.find( :select => "id,title", :include => { :providers => { :select => "id,title" } } )

How can specify fields for included table? Thx!

Answer 1

Look at this question. It isn't same question; but it probably has your answer: http://stackoverflow.com/questions/1972640/rails-render-xml-of-a-inner-join

Answer 2

Found it: http://www.freezzo.com/2009/05/20/activerecord-making-include-and-select-play-nice/