-
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
What are Schedule-Triggered Flows? | The Ultimate Guide
What are Schedule-triggered Flows? Schedule-triggered flows start up at predetermined intervals and let you automate Salesforce activities. Teams can greatly benefit from this kind of…
Building Apps Using Salesforce AppExchange
Introduction Salesforce AppExchange was launched in 2005. Salesforce AppExchange is an Online Store just like the 'Play store' in Android phones. It is the marketplace…
All You Need to Know About Apex Testing in Salesforce | The Developer Guide
Apex Testing in Salesforce The Apex Testing enables us to write and execute tests for the Apex Code. An important phase of the Salesforce development…
Popular Salesforce Videos
Salesforce Careers - Why Consider A Career In Salesforce
This Salesforce Training Video will help you understand about Salesforce, Salesforce market situation, Salesforce job trends, Salesforce career options and how Salesforce is a safe…
Welcome to the Partner Marketing Center | Salesforce
The Partner Marketing Center (PMC) is your one-stop shop for customizable marketing assets. By logging into the PMC you can easily access, customize, and deploy…
Get a Salesforce Developer Job in 5 Steps | For Freshers | For Admins | For Non-SFDC People
In this video, We will be talking about some tips to get your first job as a Salesforce Developer. If you are a recent graduate,…