Sum not working correctly

[Granville Phillips]

Seems like a simple query. The sum(d.`TargetTime`) is summing more rows than it should.

Here is the entire query. I believe it has something to do with the second sum Sum(t.dbHours) from a left join. Just not sure what to do about it.

Any help is greatly appreciated.

SELECT sum(d.`TargetTime`) as SumofTT, Sum(t.dbHours) as SumofHours, l.WebAssigned
FROM `dispatch report` d
LEFT JOIN dispatch_local l
ON d.`RepairOrderNo` = l.RepairOrder
AND d.`RepairOrderLineItem` = L.RepairLine
LEFT JOIN tbtimecard t
ON t.dbSAPRO = d.`RepairOrderNo`
AND t.dbSAPROLine = d.`RepairOrderLineItem`
WHERE (d.`RepairType` = 'ZRPO' OR d.`RepairType` = 'IHRWK') and d.`LegacyWorkCell` <> 'OUTSOURC' and d.`TargetTime` IS NOT NULL
GROUP BY l.WebAssigned