Uhm...I figured out how to do it..

 Song.find(:all, :select => "AS s artist, g.genre_name AS name_genre",
:joins => "LEFT OUTER JOIN genres AS g on songs.genre_id = g.id", :order
=> params[:sort])

-- 
Posted via http://www.ruby-forum.com/.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To unsubscribe from this group, send email to 
rubyonrails-talk+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to