joining tables

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' )

Hi
   thanks for your reply
Sijo