[John Lester]

Don't worry about dumping this on me, I'll eventually either figure out the loop or ask you to figure it out for me

Your reason for editing the post has me intrigued

Now back to the JOIN statement just for clarification since I'm almost done setting up the exclude user groups settings

user.userid = unsub_subscribethread.userid ... I thought that this would only pull the userid from the user table, hence my confusion. The entire point of joining the user table was to grab the usergroupid for use in checking user groups in the query. I am assuming that is how JOIN works (grabbing only the column listed in the ()'s ) but I also assumed that I would be done with this mod by now