INNER / UNION

[acctman]

        $res = @mysql_query("SELECT *, DATE_FORMAT(m_lld,'%m/%d/%y') AS m_lld_formatted FROM social_members 
                                        LEFT JOIN social_member_types ON t_id=m_type WHERE m_user='".$en['user']."'");

 

I need to add and INNER or UNION to the query to that I can grab all the fields from social_mcouple IF m_type = 2 THEN social_members.m_id = social_mcouple.c_id and grab all fields.

 

Can anyone assist me, thanks

[fenway]

Huh?

[Ken2k7]

Try asking again with the premise that we, the readers, are not psychic. It helps to tell us what you're trying to accomplish rather than stating you need to use INNER or UNION. How the heck would we know if we don't know what you're trying to do?