The query is correct for joining multiple tables. As you have multiple records in the child tables, the result set eventually will have multiple records.

try putting a DISTINCT in the query.