CiaN:MinDMaP the experience of reading those pages altered my anatomy

Attention mySql gurus!

Please say you can answer this question

http://www.experts-exchange.com/Databases/Mysql/Q_22042592.html

I'm totally stumped, and need an answer soon, lest I redeign my db to not be normalized and say fuck it!!!!

UPDATE: Someone came up with the answer. For all you who were scratching your heads (I know there were a few...)

select *
from users t1
where exists (select 1 from groups g, user_groups ug where g.group_id = ug.group_id and t1.user_id = ug.user_id and g.group_name='active')
and exists (select 1 from groups g, user_groups ug where g.group_id = ug.group_id and t1.user_id = ug.user_id and g.group_name='standard')

NICE