Actuall govinn had it right, i did miss a join. I feel like such a fool, thanks for the help.

ya i missed it in the post, must have copied the one i was messing with, it was actually included in my query in analyser