-
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)
Log In to reply.
Popular Salesforce Blogs

Is It a Good Idea to Implement Document Workflow Automation in Salesforce?
What is a Document Workflow? A document workflow is the process of routing, reviewing, approving, and managing documents within an organization. Document workflow software can…

Steps to Prompt Users to Login with Federated SSO in Salesforce
We have seen how to login to Salesforce using Federated authentication in my last blog - Federated Authentication Using SAML to Log in to Salesforce…

Salesforce Partner Learning Camp: A Trailhead for Partners?
Created exclusively for Salesforce partners, Salesforce Partner Learning Camp (PLC) is the primary educational resource for building service capabilities to meet customer demands. After Salesforce…
Popular Salesforce Videos
Introduction to Salesforce Marketing Cloud
Hello Everyone, In this video, by Amit Singh, we will talk about the basic introduction of the Marketing Cloud in Salesforce. Watch the video and…
Discount Categories in Salesforce CPQ
Use the discount category object to store values that you want to apply via rules to one or more products. After you associate the discount…
Salesforce Marketing Cloud Connect: Subscriber Key Migration
We demo how leveraging a subscriber key migration to remove duplicate subscribers from Sales or Service Cloud in Marketing Cloud while minimizing data loss. Explore…