Again, thanks for the quick response. I think putting it before the order by was the only place I hadn't tried. Probably just missed it in my frustration...haha The error is gone, but now I need to figure out how to check any venue that userID 116 has access to. That only works when all the duplicates are showing up. I know why, but not sure how to fix it.
Again, thanks for the much needed help. Purchasing webassist extensions has been the best thing I've done since starting web design.