-
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
Best Practices for Push Notifications and In-App Messaging in Salesforce
You receive them usually — the push notifications once you get a match on a qualitative analysis app or once there’s breaking news, they inform…
Top 5 Considerations in Choosing Your Salesforce CPQ Partner
Congratulations, you’ve made the decision to implement Salesforce CPQ! Now comes the challenging task of choosing the right Salesforce CPQ partner to help fulfill your vision…
How Does A Salesforce Consultant Shape Effective Business Strategy?
Salesforce has become one of the most popular business software in recent times. Using the same, several businesses have been effectively able to manage their…
Popular Salesforce Videos
Deploy Lightning Web Component Files | Salesforce Lightning Tutorial
Learning Objectives After watching this video, you’ll be able to: Configure Lightning web component files for display in an org. Deploy your files to an…
Apex Classes and Apex Triggers in Salesforce
In this video, Salesforce developer Artem will demonstrate real-world applications of both Apex classes and triggers with practical business scenarios. Apex classes and Apex triggers…
Time-based Workflow Rules In Salesforce | Salesforce Tutorial
Learn all about time-based workflow rules in Salesforce. This tutorial will cover the following points - 1. Create A Workflow Rule Learn how a workflow…
