# Query Help

**URL:** <https://www.ruby-forum.com/t/query-help/185450>\
**Category:** Rails\
**Created:** [March 20, 2010, 10:57am UTC](https://www.ruby-forum.com/t/query-help/185450 "2010-03-20T10:57:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![newb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2acd7d/32.png) [@newb](https://www.ruby-forum.com/u/newb)\
**Post date:** [March 20, 2010, 10:57am UTC](https://www.ruby-forum.com/t/query-help/185450/1 "2010-03-20T10:57:11Z")

</div>

HEllo all,

Kindly look into the below query

@access\_senders = GroupUser.find\_by\_sql “select distinct user\_id from  
group\_users where group\_id in (SELECT group\_id FROM group\_users where  
user\_id=2)”

when i inspect the @access\_senders i get the below

[#\<GroupUser user\_id: 2\>, #\<GroupUser user\_id: 41\>, #\<GroupUser user\_id:  
3518\>,  
#\<GroupUser user\_id: 3519\>, #\<GroupUser user\_id: 3520\>, #\<GroupUser  
user\_id: 352  
1\>, #\<GroupUser user\_id: 3522\>, #\<GroupUser user\_id: 3523\>]

now i want to append 3 into the above result set…#\<GroupUser user\_id:  
3\>

is it poosible to do …  
pls help me up

---

<div class="post-metadata">

**Author:** ![newb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2acd7d/32.png) [@newb](https://www.ruby-forum.com/u/newb)\
**Post date:** [March 21, 2010, 9:21am UTC](https://www.ruby-forum.com/t/query-help/185450/2 "2010-03-21T09:21:33Z")

</div>

You could union it in the sql or do this in ruby:

@access\_senders \<\< GroupUser.new(:user\_id =\> 3)

Cheers  
Luke

---

<div class="post-metadata">

**Author:** ![newb](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/2acd7d/32.png) [@newb](https://www.ruby-forum.com/u/newb)\
**Post date:** [March 21, 2010, 10:15am UTC](https://www.ruby-forum.com/t/query-help/185450/3 "2010-03-21T10:15:20Z")

</div>

On 20 March 2010 09:57, Newb N. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> [#\<GroupUser user\_id: 2\>, #\<GroupUser user\_id: 41\>, #\<GroupUser user\_id:  
> 3518\>,  
> #\<GroupUser user\_id: 3519\>, #\<GroupUser user\_id: 3520\>, #\<GroupUser  
> user\_id: 352  
> 1\>, #\<GroupUser user\_id: 3522\>, #\<GroupUser user\_id: 3523\>]
> 
> now i want to append 3 into the above result set…#\<GroupUser user\_id:  
> 3\>

Can you provide the model relationships (has\_many and so on) and what  
you are trying to achieve in words rather than sql?

Colin