-
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
Salesforce Product : Marketing Cloud
Salesforce Product : Marketing Cloud A platform with seven primary products that helps to reach out your customers at the right time, with the right…
Top Things You Need to Know About Communities in Salesforce
Salesforce Communities is a stage that permits our clients to interface with individuals outside their association utilizing information, cooperation, and substance. While most Salesforce clients…
4 New Salesforce Einstein Features – What it means for Service Cloud users
Salesforce Einstein Key Features – Salesforce’s recent announcement of Einstein Artificial Intelligence capabilities have quickly made headlines and for all the right reasons. With the…
Popular Salesforce Videos
Attribute Setup for Skill based Routing in Salesforce
This video is 3rd Part of the Omnichannel Series. Implementation of Attribute set up skill-based routing with the demo. Do let us know in the…
Getting Information from your Salesforce Account for a Salesforce Connection
Watch this video to learn how to get information from your Salesforce Account for a Salesforce Connection. Do let us know in the comment section…
Introduction to Salesforce Orchestrator
Flow Orchestrator was created so admins like you can quickly create sophisticated multi-user, multi-step automated business processes with clicks, not code. Experienced Salesforce Admins will…
