-
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
Invoke Apex Actions from Flow | Salesforce Flow Guide
Salesforce took editing to the next level by launching Flows, allowing users to prepare for a complex flow in a matter of minutes. However, comfort…
Things to Consider Before Integrating Salesforce with Business Applications
Customer Relationship Management (CRM) has become a need of every business. In this case, Salesforce, a cloud-based CRM, could be considered the best CRM system.…
Important Salesforce Trends To Watch Out For In 2022
Salesforce has been helping organizations manage their customer databases and automate their business processes for more than two decades now. The CRM platform is known…
Popular Salesforce Videos
Use cases Automation UiPath with Salesforce
The following video demonstrates a UiPath Robot automatically populating Salesforce using data read from an Excel spreadsheet....imagine how UiPath Robots could accelerate your Salesforce activities.…
Introduction to Creating and Using Salesforce Reports
Every Salesforce user can benefit from working with Salesforce Reports. We often say that one of the best Salesforce features is that "...even mere mortals…
The Salesforce Team is Talking About What Working for Salesforce is Like
The Salesforce team is talking about what working for Salesforce is like. Watch this video learn about their experience.
