2 mysql calls one outcome?

dreams4000

Hi all,

I have two mysql calls that get information I need by themselves, but I also need information that uses a GROUP BY on them both as there is duplicate info in each. Is there any way to do this?

-This one shows active folks
$tmpquery7 = "WHERE (mem.profil = '2' OR mem.profil = '11' OR mem.profil = '12' OR mem.profil = '13') AND pro.name != 'Inactive' AND (tea.status = '3' OR tea.status = '2') AND (pro.location = 'SD' OR pro.location = 'SD & FC') GROUP BY mem.id";

-This one shows inactive folks
$tmpquery4 = "WHERE (mem.profil = '2' OR mem.profil = '11' OR mem.profil = '12' OR mem.profil = '13') AND pro.name = 'Inactive' GROUP BY mem.id";

Basically, without going into a long description, the system sees some inactive folks as active because of a particular setting. All I need is some way to combine these two and have it group by the mem.id so duplicates are eliminated. ie there will be an account that meets both of these sql calls, and i need instead of getting 2, to only get the one. Any ideas? Thanks!

rachel2004

Have you consdered using UNION?

http://dev.mysql.com/doc/mysql/en/UNION.html

nemonoman

Just a hunch, but you might try making one query that receives all the rows, and then grouping them:

GROUP BY (tea.status = '3' OR tea.status = '2') AND (pro.location = 'SD' OR pro.location = 'SD & FC'), mem.id

On the other hand, you might try

GROUP BY mem.id, (tea.status = '3' OR tea.status = '2') AND (pro.location = 'SD' OR pro.location = 'SD & FC')

The group by clause above should return 2 rows: one of all active, 1 inaticve