I think I understand what you are getting at, but some sample data highlighting what you are currently getting and what you want to get would help significantly. To simplify this, please just include the tables/columns that are relevant to the SQL you have posted, to make it easier to read.
Cheers
Phil
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.