What is the SOQL query to get all accounts related to a contact?

Hi Delango.

Here is sample code:-

List<Account> acc=[Select Id,Name from Account];
for(Account a:acc){
List<Contact> con=[Select accountId, LastName from contact where AccountId=:a.id];

Integer TotalAnnualRevenue = 0;
for(Contact c:con){
TotalAnnualRevenue = TotalAnnualRevenue+c.AnnualRevenue
System.debug('Total revenue'+ TotalAnnualRevenue);
}

}

Hope this will help you.

Thanks.

You do a SOQL query in LOOP - Its the best practice to fail on Governor Limits