Gold supports multi-object queries (table joins). Multiple objects are specified via a comma-separated list and attributes need to be prefixed by the associated object.
Example 17-13. Print the current and total allocation summed by project
gold> Allocation,AccountProject Query Show:="GroupBy(AccountProject.Name),Sum(Allocation.Amount),Sum(Allocation.Deposited)" Allocation.Account==AccountProject.Account Allocation.Active==True
Name Amount Deposited ------------- ------------- ------------- biology 193651124 360000000 chemistry 296167659 360000000