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

**URL:** <https://www.ruby-forum.com/t/anyone-knows-how-to-do-left-join-as-well-as-inner-join-in-same-query/169402>\
**Category:** Rails\
**Created:** [June 3, 2009, 9:21am UTC](https://www.ruby-forum.com/t/anyone-knows-how-to-do-left-join-as-well-as-inner-join-in-same-query/169402 "2009-06-03T09:21:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![san2821](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4da419/32.png) [@san2821](https://www.ruby-forum.com/u/san2821)\
**Post date:** [June 3, 2009, 9:21am UTC](https://www.ruby-forum.com/t/anyone-knows-how-to-do-left-join-as-well-as-inner-join-in-same-query/169402/1 "2009-06-03T09:21:18Z")

</div>

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

> **[Blogs - Neuigkeiten - Artikel - Webseiten - Medien](https://www.sosblog.com/)**
>
> Auf SOSblog geht es um aktuelle Blogs, Neuigkeiten, Artikel, Webseiten und Medien. Wir bringen interessante neue Webseiten aus den Tiefen des Webs.

> **[Judul Situs](https://funonrails.wordpress.com)**
>
> “Cinta tidak mengenal batas. Cinta mampu melewati rintangan, melompati pagar, menembus dinding untuk mencapai tujuannya dengan penuh harapan.” — Maya Angelou

> **[Josh Software | Custom Software Development Services & Solutions](https://joshsoftware.com/)**
>
> JoshSoftware offers custom software development Services & Solution that provides enterprise, software development services for web & mobile.

---

<div class="post-metadata">

**Author:** ![san2821](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4da419/32.png) [@san2821](https://www.ruby-forum.com/u/san2821)\
**Post date:** [June 3, 2009, 9:38am UTC](https://www.ruby-forum.com/t/anyone-knows-how-to-do-left-join-as-well-as-inner-join-in-same-query/169402/2 "2009-06-03T09:38:58Z")

</div>

On Wed, Jun 3, 2009 at 9:19 AM, Sandip R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> model, :select =\>. “some attributes from all models” )
> 
> Thanks for help !
> 
> ## Sandip
> 
> Ruby on Rails Developer  
> [http://sandip.sosblog.com](http://sandip.sosblog.com)  
> [http://funonrails.wordpress.com](http://funonrails.wordpress.com)  
> [www.joshsoftware.com](http://www.joshsoftware.com)

Check the docs at

> **[ActiveRecord::Base](https://api.rubyonrails.org/classes/ActiveRecord/Base.html#M002208)**
>
> Active Record Active Record objects don't specify their attributes directly, but rather infer them from the table definition with which they're linked.

use :joins to include join SQL syntax  
:joins =\> ‘inner join x outer join y’

Andrew T.  
[http://ramblingsonrails.com](http://ramblingsonrails.com)

[http://MyMvelope.com](http://MyMvelope.com) - The SIMPLE way to manage your savings

---

<div class="post-metadata">

**Author:** ![san2821](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/4da419/32.png) [@san2821](https://www.ruby-forum.com/u/san2821)\
**Post date:** [June 3, 2009, 11:38am UTC](https://www.ruby-forum.com/t/anyone-knows-how-to-do-left-join-as-well-as-inner-join-in-same-query/169402/3 "2009-06-03T11:38:43Z")

</div>

Thanks !

On Wed, Jun 3, 2009 at 12:57 PM, Andrew T. \<  
removed\_email\_address@domain.invalid\> wrote:

> > [http://funonrails.wordpress.com](http://funonrails.wordpress.com)  
> > [http://ramblingsonrails.com](http://ramblingsonrails.com)
> 
> [http://MyMvelope.com](http://MyMvelope.com) - The SIMPLE way to manage your savings
> 
> >

–  
Ruby on Rails Developer

> **[Blogs - Neuigkeiten - Artikel - Webseiten - Medien](https://www.sosblog.com/)**
>
> Auf SOSblog geht es um aktuelle Blogs, Neuigkeiten, Artikel, Webseiten und Medien. Wir bringen interessante neue Webseiten aus den Tiefen des Webs.

> **[Judul Situs](https://funonrails.wordpress.com/)**
>
> “Cinta tidak mengenal batas. Cinta mampu melewati rintangan, melompati pagar, menembus dinding untuk mencapai tujuannya dengan penuh harapan.” — Maya Angelou

> **[Josh Software | Custom Software Development Services & Solutions](https://joshsoftware.com/)**
>
> JoshSoftware offers custom software development Services & Solution that provides enterprise, software development services for web & mobile.