select userid,username,otherdata from Utable A where username in ( select top 1 username from Utable where userid=A.userid) and otherdata in (select top 1 otherdata from Utable where userid=Auserid)
select userid,username,otherdata from Utable A where username in ( select top 1 username from Utable where userid=A.userid) and otherdata in (select top 1 otherdata from Utable where userid=A.userid)
where username in ( select top 1 username from Utable where userid=A.userid)
and otherdata in (select top 1 otherdata from Utable where userid=Auserid)
where username in ( select top 1 username from Utable where userid=A.userid)
and otherdata in (select top 1 otherdata from Utable where userid=A.userid)