# Joining tables

**URL:** <https://www.ruby-forum.com/t/joining-tables/139718>\
**Category:** Rails\
**Created:** [June 6, 2008, 10:53am UTC](https://www.ruby-forum.com/t/joining-tables/139718 "2008-06-06T10:53:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [June 6, 2008, 10:53am UTC](https://www.ruby-forum.com/t/joining-tables/139718/1 "2008-06-06T10:53:32Z")

</div>

Hi  
I have 3 tables as

1. user\_groups  
id | contact\_id | group\_id | group\_user\_type\_id
2. contact  
id | name\_first | name\_last |  
3)contact\_email\_addresses  
contact\_id | contact\_email\_address\_type\_id | emailaddress

Now I have group\_id sa for example 68  
What I want is from contact\_email\_addresses table get all the  
emailaddress with contact\_email\_address\_type\_id=2 for the contacts with  
this group\_id under the condition in the user\_groups table  
group\_user\_type\_id=2  
How can I do this?

hanks in advance  
Sijo

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [June 6, 2008, 4:30pm UTC](https://www.ruby-forum.com/t/joining-tables/139718/2 "2008-06-06T16:30:51Z")

</div>

ContactEmailAddresses.find( :all, :conditions =\>  
‘contact\_email\_address\_type\_id = 2 and group\_user\_type\_id = 2’  
:include =\>  
‘user\_groups’  
)

Something to that effect should work… however it depends how you  
have your relationships setup… this would work too…  
contact\_type = ContactEmailAddressType.find(2)  
contact\_type.contact\_email\_addresses.find(:all, :coditions =\>  
‘group\_user\_type\_id = 2’, :include =\> ‘user\_groups’ )

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [June 9, 2008, 5:56am UTC](https://www.ruby-forum.com/t/joining-tables/139718/3 "2008-06-09T05:56:29Z")

</div>

Hi  
thanks for your reply  
Sijo