ActiveRecord Table Aliases

Question

Does anyone know if it's somehow possible to setup an alias for an ActiveRecord table join?

Something like:

User.find(:all, :alias => "Users as u", :joins => "Friends as f", :select => "u.id,f.name")

Any ideas?

Answer 1

yes, but you need to include the 'ON' statement and the join statement if you overwrite the join.

User.find(:all, :", :joins => " as u INNER JOIN Friends as f ON f.user_id = u.id", :select => "u.id,f.name")