On Wed, Jun 3, 2009 at 9:19 AM, Sandip Ransing <[email protected]> wrote: > 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 ! > > Sandip > -- > Ruby on Rails Developer > http://sandip.sosblog.com > http://funonrails.wordpress.com > www.joshsoftware.com >
Check the docs at http://api.rubyonrails.org/classes/ActiveRecord/Base.html#M002208 use :joins to include join SQL syntax :joins => 'inner join x outer join y' Andrew Timberlake http://ramblingsonrails.com http://MyMvelope.com - The SIMPLE way to manage your savings --~--~---------~--~----~------------~-------~--~----~ 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 [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
