Displaying 1 result from an estimated 1 matches for "contactemailaddress".
Did you mean:
contactemailaddresses
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