[Sarcoth]

@kh99 - Thanks Kevin.

I thought about building a multidimensional array at first, but I'm not sure how to do the top level key. I'm sure that would be the usergroupids (in this case they are 40,41,42,43). I think the problem I would have with that is I would have to perform multiple queries. One for each usergroupids. Not hard to do, but I always thought it was best to do that once. That brings up my primary question, is it more efficient? Will it be slower or faster than what I have above when we get into 500+ or 1000+ records? The plus side would be that the output would go a lot smoother, no replication. The downside would be 1 query per usergroupids. Unless I'm mistaken?

I'm not sure about the ORDER BY. I would have to order by user.usergroupid, but what if the user is in one of the membergroupids instead?

This query checks to see if the user is in either the usergroupid or one of the membergroupids.