-
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
Salesforce Lightning: Two Thumbs Up
How Your Organization and Users Benefit from Salesforce Lightning Implementation Salesforce has offered the Lightning Experience for over two years, and every release update is…
Integrating Salesforce and DevOps to Streamline Your Sales Cycle
In a growth facilitating business environment, a smooth transition between development and sales is essential. Salesforce, the industry's premier CRM platform, meets DevOps, a set…
Why Salesforce Nonprofit Partners Are Essential for Your Organization’s Success
Salesforce offers a wide range of tools for sales, marketing, customer service, and analytics in one integrated system. Nonprofits use this powerful and customizable platform…
Popular Salesforce Videos
Salesforce Education Cloud Consultant: Interview Questions
Salesforce org Education Cloud is the complete customer relationship management software for colleges and universities, helping you track all of your constituent relationships, from prospects…
Salesforce CRM Full Training Tutorial For Beginners
In this video, Nick Boardman explains how to use the key features inside Salesforce CRM. He explains various dashboard options, setting up campaigns etc.