joannechester/au.joanne.accountcodesummary — pull request #1 by eileenmcnaughton (2013-11-14 03:24:28+00:00)
Title: Your first pull request

Hi JoAnne I have fixed the immediate errors in the report & the fix is in this PR.

Basically the correct way to join on a table more than once in a civicrm report is to declare it more than once. So it could be

'individual' => array('name' => 'civicrm_contact', .... declare fields etc
'organisation' => array('name' => 'civicrm_contact' ... declare fields etc

& as far as civi report is concerned they are completely different tables.

However, the report you used has declared different instances of the same table as if they were just one table & has some hacks to deal with that in the other functions