Anyone knows how to do left join as well as inner join in same query.

Hello All,

Is rails supporting left and inner joins in same query ??
I dont wanted to do it using find_by_sql.

I have model having belongs_to and has_one associations.

I wanted to something like…

Model.find ( :all, left join on belongs_to model and inner join on has_one model, :select =>. “some attributes from all models” )

Thanks for help !


Check the docs at

use :joins to include join SQL syntax
:joins => 'inner join x outer join y'

Andrew Timberlake - The SIMPLE way to manage your savings

Thanks !