-
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
Maximizing Marketing value through Salesforce Datorama Marketing Intelligence and Analytics Tools
Salesforce Datorama – With about 7000 marketing technology solutions disrupting the marketing platform, it has been a constant challenge for marketers to get a 360-degree view of…
Learn How to Use Custom Settings in Salesforce
What is Custom Setting? Custom Settings resemble custom items. They are by and large used to make custom arrangements of information and can be related…
Schedule Your Path in Salesforce Flow | Developer Guide
Advantages of Flow Builder over Process Builder Process builder does work on delete the records Flow work on a different object while Process Builder only…
Popular Salesforce Videos
8 Steps to Launch Your App on Salesforce AppExchange
AppExchange is the largest business app store in the world, with over 4,000 apps and millions of users. In this video, we will guide you…
Lesser Known VSCode Tips for Salesforce Developers
More Code, Less Work. Whether you are a beginner or an advanced developer, smart tips, and sharp tools can significantly improve your productivity. There are…
Future Methods | Asynchronous Apex | Salesforce Tutorial
Asynchronous Apex 1. Future Methods 2. Making callout using future method 3.Avoiding Mixed Dml using Future Method 4. Why sObjects and objects cannot pass as…
