Help - complex joins

[Bad Programmer]

I've got 3 tables:
attrib_division_rl,
attrib_organization_rl,
employee

Both attrib tables have an AttributionID, the employee table has an EmployeeID

I have a table called answers with an AttributionID and an EmployeeID.

This SQL does not work correctly.
The averages and scores are completely off.
For a given record it should be all the answers for the given division, organization & employee.
I'm getting wrong averages and counts that are way too high.
How can I write this (or any other technique) to get this correct?


SELECT
AVG(answers.Score) AS ScoreAvg, CNT(answers.Score), attrib_division_rl.ID As DivisionID, attrib_organization_rl.ID AS OrganizationID, EmployeeID

FROM answers INNER JOIN attrib_division_rl
LEFT JOIN attrib_organization_rl
LEFT JOIN employees AS tblEmp
ON attrib_organization_rl.AttributionID IN (SELECT AttributionID FROM answers WHERE EmployeeID = tblEmp.EmployeeID)
ON attrib_division_rl.AttributionID = attrib_organization_rl.AttributionID
ON answers.AttributionID = attrib_division_rl.AttributionID

GROUP BY DivisionID, OrganizationID, EmployeeID