The results you are getting appear correct in a one-many relationship.

If this isn't what you need, I'd review the business requirments and the database design.