[Falcon Capt]

Originally Posted by ranz

...
WHERE subscriptionid = 6 AND subscriptionid <> 1 AND status = 0 AND usergroupid =2

should do it.

I had already tried that exact solution but the problem is the 2 subscriptions are on different rows. So using the above there will never be a subscriptionid of 6 & 1 on the same row, so the above returns EVERYONE who has had a subscriptionid = 6 regardless of whether they have had a subscriptionid = 1 or not. I need to have it not return people who have had both 1 & 6 and only return those who have only had subscriptionid = 6.

I need a query that checks for multiple entires (row) having the same userid and different subscriptionid's and not return a result for userid's that have more than one entry (row).