-
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
Tips To Use Salesforce Effectively, With Salesforce Online Training
Salesforce is one of the most popular CRM platforms. In recent years, there is a massive increase in the number of companies that are proudly…
Apex Triggers in Salesforce | Here’s What you Need to Know
What are Apex triggers? Apex triggers permit custom moves to be done before or after data manipulation language (DML) activities arise in Salesforce, such as…
Salesforce & SharePoint Integration – A Combination To Enhance Business Processes
Salesforce SharePoint Integration – Salesforce is the world’s #1 cloud-based CRM giant offering comprehensive CRM solutions to millions of leading brands across the globe. However,…
Popular Salesforce Videos
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…
Data Cleansing in Salesforce and Salsa - Why it matters?
Research by Blackbaud found that 67% of data available to some nonprofits were un-mailable. That is either a lost opportunity or wasted money. This especially…
How to Set Up Salesforce Customer Community
Step by Step Salesforce tutorial for quickly setting up a Customer Community with Customer Service (Napili) Template.
