[kh99]

Originally Posted by John Lester

I got that select bit from reading over at stackoverflow, was pretty sure it wouldn't work but it didn't spit out an error either

What I was trying to say above (except that I messed up that sentence and it doesn't make any sense) is that it may well be correct, I just don't know.

Your suggestion did not work either I had tried using a JOIN (left and right) and neither worked, which is why I had nothing to lose by trying the query I posted

Hmm...I tested mine before posting it and it seemed to work. I adjusted the WHERE stuff so that it would match one of my test users, but I don't think that should have made any difference.