Thanks for the quick reply.

Not sure if I was clear in what I'm trying to accomplish with this query.

What I'm trying to do is count the number of times a USERID appears in the WHOVERIFIED and WHOCHECKED columns of the RXPRODUCTIVITY table and return the results in the following format:

USERID| WHOVERIFIED| WHOCHECKED

12345 51 0

2345 10 0

3456 0 23

If I use this query, I get the correct output but it lacks the WHOCHECKED column:

select whoverified AS 'userid', count(*) whoverified

from rxproductivity

join users

on rxproductivity.whoverified = users.userid

group by whoverified

having count(whoverified) > 1

order by count(whoverified) desc

I really appreciate your help with this.