Re: Specifying multiple WHERE options within a group?

[Jay Pipes]

SELECT COUNT(DISTINCT ua.UserID)
FROM UserActions ua
INNER JOIN (
SELECT UserID FROM UserActions
WHERE Action = 'Request Download'
) AS uad
ON ua.UserID = aud.UserID
INNER JOIN (
SELECT UserID FROM UserActions
WHERE Action = 'Page View'
) AS uap
ON ua.UserID = aup.UserID;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com