Displaying 1 result from an estimated 1 matches for "contact_email_address".
Did you mean:
contact_email_addresses
2008 Jun 06
2
joining tables
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 tab...