Sorry,

SELECT dbo.t_role_map.*
FROM dbo.t_role_map
WHERE (uID IN
(SELECT uID
FROM dbo.t_role_map
WHERE (rID = 100)
GROUP BY uID, rID
HAVING (COUNT(rID) > 1))) AND (rID = 100)

I would like to Order By uID.

>>The following select works without the 'order by' clause. When I put it in, it also adds 'top 100 percent' by default, and generates an error. I have tried saving the select without the 'order by' and calling it from another select (view), but that still generates the error. Is there an easy way to do this??
>>
>>Thanks in advance!
>
>Uh, what select?