-
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
Top 5 Salesforce TrailheaDX 2020 Keynotes Highlights
Hello, enthusiasts, we are thrilled to bring you the highlights of TrailheaDX 2020. There was a lot of buzz and anticipation surrounding this year’s Trailhead since…
Driving Your Innovation Process With an Ideas Management Software | Salesforce
Have you ever thought about how organizations innovate? Well, every innovation was once just an idea and ideas come your way when least expected. The…
All About Record-Triggered Flows in Salesforce | The Salesforce Trailhead Guide
In this blog, we will discuss the topic of Triggered flows. There are three general types of flows: Screen Flow Auto launched Flow Triggered Flow …
Popular Salesforce Videos
Email to Case Advance | Converting Cases from Emails Effectively | Salesforce Tutorial
Email-to-Case Advance is an enhanced version of the Salesforce Email-to-Case functionality that converts customer email to cases. It works for Salesforce Service Cloud and provides…
Summer Internship | Career with Salesforce
This Summer, dive into the ocean of Salesforce with S2 Labs Apply for the much-awaited S2 Labs Summer Internship Program and start accelerating your career…
Salesforce Interview | Marketing Cloud Success
What's it like to learn Marketing Cloud from scratch? Akasia Perran has the answers and in this video, I ask her about her experience starting…
