-
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
Deliver Transparency and Collaboration with Salesforce Manufacturing Cloud
The manufacturing industry is unique in many ways. With so many parties involved in a single project and big contracts at stake, it’s crucial for…
Accessibility in Salesforce - An Overview
What is Accessibility? In practice, accessibility is intended for users with disabilities. Globally, nearly 300 million people have some form of visual impairment and nearly…
Learn How to Create Record Using Flow in Salesforce
Go to Setup, enter flow in Quick Find then select Flows. Click on New Flow. From the template, select Screen Flow. Go to Object Manager…
Popular Salesforce Videos
Introduction to Report and Dashboard in Salesforce | Salesforce Training Videos
A report is a list of records that meet the criteria you define. It's displayed in Salesforce in rows and columns, and can be filtered,…
Manual & Apex Managed Sharing in Salesforce
In this video, we will talk about Manual Sharing and Apex Managed Sharing. Manual Sharing Manual Sharing is used to share the record Manually. For…
Heroku | Salesforce Development Course
Knowledge of Heroku is also required to crack the Salesforce PD 1 Certification Examination. Let’s understand what Heroku is and what are its uses, in…
