# How to get a join query to work?

**URL:** <https://www.ruby-forum.com/t/how-to-get-a-join-query-to-work/190898>\
**Category:** Rails\
**Created:** [June 30, 2010, 11:58am UTC](https://www.ruby-forum.com/t/how-to-get-a-join-query-to-work/190898 "2010-06-30T11:58:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![caiwangqin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/4bbf92/32.png) [@caiwangqin](https://www.ruby-forum.com/u/caiwangqin)\
**Post date:** [June 30, 2010, 11:58am UTC](https://www.ruby-forum.com/t/how-to-get-a-join-query-to-work/190898/1 "2010-06-30T11:58:43Z")

</div>

Award.all(:joins =\> “INNER JOIN overall\_rankings ON  
(overall\_rankings.poem\_id = awards.poem\_id)”) gets the wrong  
award.overall\_ranking on heroku postgres

Poem  
has\_many :awards  
has\_one :overall\_ranking

Award  
belongs\_to :poem  
has\_one :overall\_ranking, :foreign\_key =\> :poem\_id

OverallRanking  
belongs\_to :poem

---

<div class="post-metadata">

**Author:** ![caiwangqin](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/4bbf92/32.png) [@caiwangqin](https://www.ruby-forum.com/u/caiwangqin)\
**Post date:** [June 30, 2010, 4:03pm UTC](https://www.ruby-forum.com/t/how-to-get-a-join-query-to-work/190898/2 "2010-06-30T16:03:56Z")

</div>

Jesse C. wrote:

> Award.all(:joins =\> “INNER JOIN overall\_rankings ON  
> (overall\_rankings.poem\_id = awards.poem\_id)”) gets the wrong  
> award.overall\_ranking on heroku postgres
> 
> Poem  
> has\_many :awards  
> has\_one :overall\_ranking
> 
> Award  
> belongs\_to :poem  
> has\_one :overall\_ranking, :foreign\_key =\> :poem\_id
> 
> OverallRanking  
> belongs\_to :poem

# Solution

Award  
has\_one :overall\_ranking, :foreign\_key =\> :poem\_id, :primary\_key =\>  
:poem\_id

Award.all(:include =\> :overall\_ranking)