Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #72.9K
2 Posted Topics
Try sum(ifnull(settlement.amount,0)) as 'Total Received'
Your query string doesn't contain any selection criteria to limit the records pulled. If the person has 4 records in the payroll file, then you will get 4 repeats in the details. Try adding a filter such as "where date = 2/21/12" to your query string.
The End.