# Activerecord joins models

**URL:** <https://discuss.rubyonrails.org/t/activerecord-joins-models/60246>\
**Category:** rubyonrails-talk\
**Created:** [August 6, 2011, 10:21am UTC](https://discuss.rubyonrails.org/t/activerecord-joins-models/60246 "2011-08-06T10:21:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sayuj\_Othayoth](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@Sayuj\_Othayoth](https://discuss.rubyonrails.org/u/Sayuj_Othayoth)\
**Post date:** [August 6, 2011, 10:21am UTC](https://discuss.rubyonrails.org/t/activerecord-joins-models/60246/1 "2011-08-06T10:21:12Z")

</div>

```ruby
Association named 'status_messages' was not found; perhaps you misspelled it?

```

Hi, My models: #StatusMessage model **class StatusMessage \< ActiveRecord::Base belongs\_to :users default\_scope :order =\> “created\_at DESC” end** #User Model **class User \< ActiveRecord::Base has\_many :statue\_messages end** In controller I want to join these two tables. When I use : _**@status = User.joins(:status\_messages)**_

It generate an error How can I fix this?

---

<div class="post-metadata">

**Author:** ![Frederick\_Cheung](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/frederick_cheung/32/3901_2.png) [@Frederick\_Cheung](https://discuss.rubyonrails.org/u/Frederick_Cheung)\
**Post date:** [August 6, 2011, 10:58am UTC](https://discuss.rubyonrails.org/t/activerecord-joins-models/60246/2 "2011-08-06T10:58:34Z")

</div>

> Hi,
> 
> My models:
> 
> #StatusMessage model \*class StatusMessage \< ActiveRecord::Base belongs\_to :users default\_scope :order =\> "created\_at DESC" end\*
> 
> #User Model \*class User \< ActiveRecord::Base has\_many :statue\_messages end
> 
> \*In controller I want to join these two tables. When I use : \*@status = User.joins(:status\_messages)\*
> 
> It generate an error
> 
> Association named 'status\_messages' was not found; perhaps you misspelled it?
> 
> How can I fix this?

It looks like you misspelled your association - your has\_many doesn't match what you've passed to User.joins

Fred

---

<div class="post-metadata">

**Author:** ![tudor\_cornea](https://avatars.discourse-cdn.com/v4/letter/t/ec9cab/32.png) [@tudor\_cornea](https://discuss.rubyonrails.org/u/tudor_cornea)\
**Post date:** [August 6, 2011, 2:40pm UTC](https://discuss.rubyonrails.org/t/activerecord-joins-models/60246/3 "2011-08-06T14:40:09Z")

</div>

Try:

has\_many :StatueMessages instead of:

**has\_many :statue\_messages**

---

<div class="post-metadata">

**Author:** ![Sayuj\_Othayoth](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@Sayuj\_Othayoth](https://discuss.rubyonrails.org/u/Sayuj_Othayoth)\
**Post date:** [August 6, 2011, 6:45pm UTC](https://discuss.rubyonrails.org/t/activerecord-joins-models/60246/4 "2011-08-06T18:45:54Z")

</div>

Thank you I misspelled **has\_many :status\_messages**

thank you very much