[thesite] rudy, this may intersest you..

[Joshua Olson]

: i'll think about it some more.. quicky question. how would i run that
: query and get the persons last login date too?
:
: select who,  lastlogin, createdate from users group by email having
: count(*) > 1
:
: is giving me a "Not a group by" expression.. sorry about the dumb
: questions, I'm only on page 75 of my "Learn to be Rudy in 21 days" book :)

I don't think that'll work because you cannot return this sort of row level
detail when you have a group by in there.

Try:

select who,  lastlogin, createdate
from users
where exists
  (select 1 from users u2
   where u2.email = users.email
        and u2.userid != user.userid)

Or something like that.  There may be some fancy group by variation, but
this aughta work (mind you, I'm not sure if userid is the correct fieldname)

-joshua