Skip to main content
Topics#ApexLAKSHMINARASIMHA REDDY's Question
LAKSHMINARASIMHA REDDY (DXC Technology) asked in #Apex
Jan 9, 2017, 6:39 AM

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..

 
3 answers
  1. Amit Chaudhary (ApexHours)
    Jan 9, 2017, 5:45 PM

    You Can try below query

    select id,name from account where Id not in(select accountid from contact)

    You Can try below queryselect id,name from account where Id not in(select accountid from contact)Please check below post to learn about SOQL1) https://developer.salesforce.com/docs/atlas.en-us.

    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

     
Loading
Write an answer...
0/9000