jrseven68 (3/25/2013)
Hey thanks.This works perfectly with what i am trying to do.
The only down side to using this is it does not return results where userid's have 0 records in both whoverified and whochecked columns of the rxproductivity table.
Other than that, it is just what I need.
Thanks for your help.:-)
Try replacing the INNER JOIN with LEFT OUTER JOIN in the query
That should give you the desired results.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/