zeroeth · September 1, 2010 22:15
diff --git a/gistfile1.sql b/gistfile1.sql
 -- supplied with two group ids, return all users with ONLY those two groups.

 SELECT users.*, count(*) as grp_count
  FROM users
  JOIN users_groups
    ON users.id = users_groups.user_id
 WHERE users_groups.group_id in (730, 733)
 GROUP BY users.id
 HAVING count(*) = 2
	-- supplied with two group ids, return all users with ONLY those two groups.

	SELECT users., count() as grp_count
	FROM users
	JOIN users_groups
	ON users.id = users_groups.user_id
	WHERE users_groups.group_id in (730, 733)
	GROUP BY users.id
	HAVING count(*) = 2