# :select with find\_in\_batches

**URL:** <https://www.ruby-forum.com/t/select-with-find-in-batches/194621>\
**Category:** Rails\
**Created:** [September 8, 2010, 3:35am UTC](https://www.ruby-forum.com/t/select-with-find-in-batches/194621 "2010-09-08T03:35:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![badnaam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/e36b37/32.png) [@badnaam](https://www.ruby-forum.com/u/badnaam)\
**Post date:** [September 8, 2010, 3:35am UTC](https://www.ruby-forum.com/t/select-with-find-in-batches/194621/1 "2010-09-08T03:35:50Z")

</div>

How can I include a :select clause with find\_in\_batches. The following  
throws an error " Mysql::Error: Unknown column ‘users.id’ in ‘field  
list’: .

```
Post.find_in_batches(:batch_size => 100, :select => "users.id,

```

users.name, categories.name, posts.id", :include =\>  
[:user, :category]) do |group|  
#stuff with group  
end

---

<div class="post-metadata">

**Author:** ![badnaam](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/e36b37/32.png) [@badnaam](https://www.ruby-forum.com/u/badnaam)\
**Post date:** [September 8, 2010, 9:08am UTC](https://www.ruby-forum.com/t/select-with-find-in-batches/194621/2 "2010-09-08T09:08:20Z")

</div>

On Sep 8, 2:30 am, badnaam [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> How can I include a :select clause with find\_in\_batches. The following  
> throws an error " Mysql::Error: Unknown column ‘users.id’ in ‘field  
> list’: .

If you want joins use :joins rather than :include

Fred