We are running a relationship SOQL query (Account and Contact) which both have a FAX field.  We have tried to alias the field names to distinguish the two fields without success.  In the queryresult set, we can correctly reference one field through the "FAX" field name.  Question:  How do we reference the other FAX field?

 

Also, if there is a good SOQL reference, could you please point us in the right direction. 

 

Thank you.

We are running a relationship SOQL query (Account and Contact) which both have a FAX field.  We have tried to alias the field names to distinguish the two fields without success.  In the queryresult set, we can correctly reference one field through the "FAX" field name.  Question:  How do we reference the other FAX field?

 

Also, if there is a good SOQL reference, could you please point us in the right direction. 

 

Thank you.