I got iit to work.

I had to split the query to 2. The two tables were conflicting with eachother. so now it works

Thanks for helping me everyone.
can anybody help me with this part of the code?
If the query didn't come up with any results that matched to their usergroup.
How can I make so that there is error message saying "No Results blah blah"?
if it found results it would just display them normally.
Thanks In Advance!