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