-
SOQL to find Accounts without Contacts AND Opportunities in Salesforce
I am looking for help to run a Join Query to find all out Accounts in our Database without Contacts AND Opportuntiy. I can run the query indepetly, but I would like to join the queries.
The Query I am runing to find Accounts without Contacts: Select Id, Name From Account Where Id NOT IN (SELECT AccountId FROM Contacts)
Query to find Accounts without Opportunties: Select Id, Name From Account Where Id NOT IN (SELECT AccountId FROM Opportunity)
Log In to reply.
Popular Salesforce Blogs
How Using Salesforce Chatter Can Serve a Business
Salesforce Chatter is an enterprise social network used in many companies for team engagement and collaboration. The platform came up as an extension to Salesforce1…
Salesforce Chatter vs Slack - A Comparative Analysis
As part of its strategic acquisition policy, Salesforce surprised the world with the billion-dollar acquisition of Slack Technologies Inc. In the words of Marc Benioff,…
Top Sales Cloud Features From The Salesforce Winter '22 Release
With each release, Salesforce products become more user-friendly. Salesforce Sales Cloud is already the best sales CRM in the world but this new Salesforce Winter…
Popular Salesforce Videos
Non Technical but Want to Build Career in Salesforce?
In this video Shrey gave the answer of the following questions: 1. What is the next step after doing Certification in Salesforce Administrator? 2. How…
How To Use RingCentral App In Salesforce | Salesforce Service Cloud
Learn how to use RingCentral App in Salesforce. This video will cover the following points - 1. Advantages Take a look at the advantages of…
What are Profiles and Permission Sets in Salesforce ? | Object Level Security in Salesforce
In this video, Shrey have explained complete Object Level Security in Salesforce which includes: 1. What is the significance of defining Object-level security in Salesforce?…