SOQL query to retrieve Accounts and their related Contacts.

• Use the relationship field 'Contacts' on the Account object to retrieve related contacts.

• Use the SELECT statement to specify the fields to re...read more

Select id, Name, (select id, firstName from Contacts) from Account