So the use case is as follows:  On the Account page there is the territories field that for a given account will show whatever territories are assigned to that particular Account.  So, as an example, Acme Corp. may show a territories field of National, Northeast, and NY on the page.  However, in reporting, SFDC returns for the Account by territories report individual line items for Acme Corporation for National, Northeast and NY respectively.  The consumer requirement here is to report on territories for Accounts in the same manner they are displayed on the Account page: all concatenated within the same field.

So given there is no way to do this via formula, I investigated doing via Apex.  It turned out that 4 objects would be needed to produce the territory relationship for Accounts: Account, AccountShare, Group, & Territory.  However, the kicker is that basically 3 separate queries are needed to accoumplish this.  The parent-child relationships are not accessble in SOQL, and of course you can't do joins between objects like you can in T-SQL unless there is that parent-child relationship.

So I attempted a batch job to somehow put this together.  However, my approach is wrong in that I am running into query limits with my compiled code, and I am not sure how to structure this to get around the problem.  Below is my compliled code that errors out.  Guidance would be appreciated.  Thanks in advance, TDM
 

global class batchTerritoryCustomUpdate implements Database.Batchable<sObject>

{
    //The purpose of this batchClass is to return concatenated Territory Names to the Account object custom field Account_Territory__c for reporting purpose specific to user requests
    
    global Database.QueryLocator start(Database.BatchableContext BC)
    
    {  
        String query = 'Select Id From Account';
        return Database.getQueryLocator(query);      // returns AccountId and UserOrGroupId for queries below.  

    }
    global void execute(Database.BatchableContext BC, List<Account> scope)
    {
        Integer i = 0;
                
        for(Account updateAccount : scope)
        {    
            String acctID = updateAccount.Id;
            String relId;
            String groupId;
            String matchinAcctId;
            List <AccountShare> aShare = new List <AccountShare>();
            aShare = [Select AccountId, UserOrGroupId from AccountShare Where RowCause = 'Territory' and AccountId =: acctID];
            Do{
            for(AccountShare ash : aShare)  // setup accounts for update
            { 
                groupId = ash.UserOrGroupId;
                List <Group> pickGroup = new List<Group>();
                pickGroup = [Select RelatedId from Group where Type ='Territory' and Id =: groupId];
                
                For(Group selectGroup : pickGroup)  //loop through Group data
                {
                    
                    relId = selectGroup.RelatedId;
                    String terrName = '|';
                    List <Territory> terra = new List <Territory>();
                    terra = [Select Name from Territory Where Id =: relId];
                    for(Territory terraNova : terra)  //loop through Territory data
                    {
                        List <Account> matchAccount = new List <Account>();
                        matchAccount = [Select Id from Account where Id =: acctId];
                        For(Account finalAcct : matchAccount)
                        { 
                                terrName = terrName + terraNova.Name + '|'; 
                                matchinAcctId = finalAcct.Id;
                                finalAcct.Id = acctId;
                               
                            updateAccount.Account_Territory__c = terrName;  //write the concatenated territories to the custom Account field
                        
                        }
                     }
                 }
                
                
                }
            } while(matchinAcctId==acctId);
           update scope;
        }    
    }    
       
    global void finish(Database.BatchableContext BC)
    {
    }
    
    
}