# Left outer join inside another?

**URL:** <https://www.ruby-forum.com/t/left-outer-join-inside-another/92785>\
**Category:** Rails\
**Created:** [April 24, 2007, 5:40am UTC](https://www.ruby-forum.com/t/left-outer-join-inside-another/92785 "2007-04-24T05:40:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cfingerh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/f14d63/32.png) [@cfingerh](https://www.ruby-forum.com/u/cfingerh)\
**Post date:** [April 24, 2007, 5:40am UTC](https://www.ruby-forum.com/t/left-outer-join-inside-another/92785/1 "2007-04-24T05:40:25Z")

</div>

I have three tables

“kids” which belongs\_to “families” which belongs “group”  
I want to get all the kids from a certain group

I have my models

class Kid \< ActiveRecord::Base  
belongs\_to :family  
end

class Family \< ActiveRecord::Base  
belongs\_to :group  
end

in my controller I’m trying

@kids = Kid.find(:all, :include =\> [:family],:conditions=\>["  
‘group.country’=? ", params[:id]])

Do I have to add to the include " :include =\> [:family,:group]  
" ?  
Or do I have to add something the Kid model ?

Thanks