I have this query below where in the output Account.Corportate_Code__c and Account.Industry column values are being concatenated as "AccountSNHUEducation" .

Account.Corportate_Code__c has value = SNHU
Account.Industry = Education

SELECT id,Account.Corportate_Code__c, StartDate, EndDate,Number_of_Backup_days_in_contract__c,Account.Industry, CreatedDate, LastModifiedDate, (SELECT id FROM Opportunities) FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'

I am running this query in Python and my code is:
query = (
                "SELECT Account.Corportate_Code__c, id, Account.Industry,  (SELECT id FROM Opportunities)  FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'")
            records = svc.query(query)
for rec in records[sf.records:]:
                        #out.write(rec)
                        print  str(rec[1]) + " : " + str(rec[2]) + " : " + str(rec[3]) + " : " + str(rec[4])

 

I have this query below where in the output Account.Corportate_Code__c and Account.Industry column values are being concatenated as "AccountSNHUEducation" .

Account.Corportate_Code__c has value = SNHU
Account.Industry = Education

SELECT id,Account.Corportate_Code__c, StartDate, EndDate,Number_of_Backup_days_in_contract__c,Account.Industry, CreatedDate, LastModifiedDate, (SELECT id FROM Opportunities) FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'

I am running this query in Python and my code is:
query = (
                "SELECT Account.Corportate_Code__c, id, Account.Industry,  (SELECT id FROM Opportunities)  FROM Contract WHERE Status = 'Activated' AND RecordTypeId = '01270000000Hp9oAAC'")
            records = svc.query(query)
for rec in records[sf.records:]:
                        #out.write(rec)
                        print  str(rec[1]) + " : " + str(rec[2]) + " : " + str(rec[3]) + " : " + str(rec[4])