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.
Quote:
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.
09-15-2012, 09:16 PM
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 
Threaded Mode