To get contact of account with name starting with abc, use Salesforce's SOQL query language.

• Use the Salesforce Object Query Language (SOQL) to query the Account object

• Use the 'LIKE' operator to search...read more

Surname first name middle name then accotant number

In this salutations we will write query on object & this query is like parent to child query

[Selected id, name,(select id, name, phone__c from contacts) from account where account. Name like 'abc%']

Af...read more

SELECT Id, Name FROM Contact WHERE Account.Name LIKE 'abc%'