[thesite] rudy, this may intersest you..

[rudy]

> I don't think it does because of the
> u2.userid != user.userid conditional.

of course [whacks self on forehead]

you're right, each row is returned once

the outer query was, after all, looking for row details

(i musta been thinking of how many groups,
which is a slightly more complex query...)

by the way, your query is awfully hard to extend
beyond duplicates -- what would it look like if you
were trying to list all users where there were three
of them with the same email?

;o)




>That makes sure it excludes counting itself.
>
>Of course, putting the group by subquery in the IN clause is a much better
>answer.  Can you say, deja vu?  I think we covered something like this on
>thelist about a month ago.
>
>And then you say,
>
>: (he said, confidently, not having bothered to test it)
>
>DOAH!
>
>
>-joshua
>
>
>
>
>
>_______________________________________________
>For unsubscribe, archive, and options, go to:
>http://lists.evolt.org/mailman/listinfo/thesite
>