function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lakshmi SLakshmi S 

soql query for fetching records from Account not related to Contact object?

Hi Dev's,

SOQL query for fetching records from Account not related to Contact object?(Only account records, which are not related to contact)?

Regards
Lakshmi

Thanks in advance..
 
Best Answer chosen by Lakshmi S
Amit Chaudhary 8Amit Chaudhary 8
You Can try below query 
select id,name from account where Id not in(select accountid from contact)

User-added image

Please check below post to learn about SOQL
1) https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm
2) https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships.htm
3) https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_understanding.htm#sforce_api_calls_soql_relationships_understanding
4) https://trailhead.salesforce.com/en/apex_database/apex_database_soql
5) https://developer.salesforce.com/page/A_Deeper_look_at_SOQL_and_Relationship_Queries_on_Force.com

Let us know if this will help you
 

All Answers

bilal malikbilal malik
        List<Contact> con = [Select name,Account.id from contact];
        List<Id> acc_ids = new List<Id>();
        for(Contact c : con){
            if( c.account.id != null)
            {
                acc_ids.add(c.account.id);
            }
        }
        List<Account> list_accounts = [Select id,name from account where id not in :acc_ids];
        system.debug(list_accounts);
Mahesh K 22Mahesh K 22
Hi Lakshmi

1.This query for without relationship with contact ,that means only account records.

list<account> acc = [select id,name from account where Id not in(select accountid from contact)];
system.debug('========='+acc.size());
 
2.This query for relationship between contact and account records.

list<account> acc2 = [select id,name from account where Id in(select accountid from contact)];
system.debug('========='+acc2.size());
Amit Chaudhary 8Amit Chaudhary 8
You Can try below query 
select id,name from account where Id not in(select accountid from contact)

User-added image

Please check below post to learn about SOQL
1) https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm
2) https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships.htm
3) https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_understanding.htm#sforce_api_calls_soql_relationships_understanding
4) https://trailhead.salesforce.com/en/apex_database/apex_database_soql
5) https://developer.salesforce.com/page/A_Deeper_look_at_SOQL_and_Relationship_Queries_on_Force.com

Let us know if this will help you
 
This was selected as the best answer