# best way to perform a certain DB query

**URL:** <https://discuss.rubyonrails.org/t/best-way-to-perform-a-certain-db-query/22329>\
**Category:** rubyonrails-talk\
**Created:** [December 28, 2007, 12:23pm UTC](https://discuss.rubyonrails.org/t/best-way-to-perform-a-certain-db-query/22329 "2007-12-28T12:23:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Carolene](https://avatars.discourse-cdn.com/v4/letter/c/b3f665/32.png) [@Carolene](https://discuss.rubyonrails.org/u/Carolene)\
**Post date:** [December 28, 2007, 12:23pm UTC](https://discuss.rubyonrails.org/t/best-way-to-perform-a-certain-db-query/22329/1 "2007-12-28T12:23:37Z")

</div>

Hope this resolves:

User.find(:all, :conditions =\> ['rich is true'], :select =\> 'distinct book\_name', :include =\>[:books])

---

<div class="post-metadata">

**Author:** ![Carolene](https://avatars.discourse-cdn.com/v4/letter/c/b3f665/32.png) [@Carolene](https://discuss.rubyonrails.org/u/Carolene)\
**Post date:** [December 28, 2007, 1:04pm UTC](https://discuss.rubyonrails.org/t/best-way-to-perform-a-certain-db-query/22329/2 "2007-12-28T13:04:55Z")

</div>

If you just need the names of books for rich users ... then you need to add user\_id column to books table, then give your regular query for books table directly.