Problem With Sum & Join

Problem With Sum & Join

El Forum
Guest

07-14-2010, 12:22 PM

[eluser]WanWizard[/eluser]
This isn't really a CI issue, but a SQL issue.

As a test, remove the group_by, remove the SUM (just include the payment field), run the query, and do a var_dump($report_data). Do you see the records you expect? This should be the detail records that are summed by the group_by.

Messages In This Thread

Problem With Sum & Join - by El Forum - 07-14-2010, 07:45 AM

Problem With Sum & Join - by El Forum - 07-14-2010, 07:58 AM

Problem With Sum & Join - by El Forum - 07-14-2010, 09:52 AM

Problem With Sum & Join - by El Forum - 07-14-2010, 10:37 AM

Problem With Sum & Join - by El Forum - 07-14-2010, 10:52 AM

Problem With Sum & Join - by El Forum - 07-14-2010, 12:22 PM