-
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) -
1 Reply
-
Hi Radakrishna,
Use this
Select Id, Name from Account where ID NOT IN (Select AccountId from Contact) AND ID NOT IN (Select AccountId from Opportunity)
Log In to reply.
Popular Salesforce Blogs
How Salesforce CPQ Software Eliminates Sales Hurdles?
In this era of an automated CRM solution like Salesforce CPQ, if your sales team is still struggling in generating quotes, writing proposals and closing…
Working and Usage of lightning:recordEditForm | Salesforce Developer Guide
Build a form with the lightning:recordEditForm component to add a Salesforce record or change fields in an existing record. The part shows fields along with…
All About Salesforce Health Check 101
If you are a Salesforce admin, your major worry must be security. You will be extra cautious as you are handling customer data and yes,…
Popular Salesforce Videos
Salesforce Consultant Career | Salesforce Career Path | Salesforce Consultant Certification
If you're interested in becoming a Salesforce consultant, one of the first things to consider is how much education you need. We've determined that 60.2%…
Salesforce DX simplified with AutoRABIT - Bay Area Salesforce Developer Group
A common need that teams developing on the Salesforce platform express is the desire for a single solution that will take their developers through the…
CEPTES’s successful visit to Dreamforce’17
Thank you all to those who visited CEPTES at Dreamforce’17. It had been a great event and CEPTES would like to offer gratitude to our…
