Querying Distinct Users

[Skanless]

Hello, I am attempting to select all users who are visiting our site with multiple IPAdresses. I wrote the query below but it is not doing what I want it to do. Any assistance in accomplishing this task will be greatly appreciated. Select UserID from AU_commontable where UserID IN if exists(Select ipaddress as IP, count (ipaddress )as Total --, userID,logdate from AU_commontable where result=1 and actiontaken='firsttimesignon' group by ipaddress having (count(ipaddress)>1))

Skan If you knew it would not compile why didn't you tell me?!?!?!

[M H 1 2 3]

select userid,ipaddress, count(1) as[number of unique ipaddress] from AU_commontable where result=1 and actiontaken='firsttimesignon' group by userid,ipaddress having count(1)>1