Thanks ! On Wed, Jun 3, 2009 at 12:57 PM, Andrew Timberlake < [email protected]> wrote:
> > 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 > > > > -- Ruby on Rails Developer http://sandip.sosblog.com http://funonrails.wordpress.com www.joshsoftware.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 [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 -~----------~----~----~----~------~----~------~--~---
