Toggle Side Panel

  • Blogs
  • Consultants
    • Salesforce Product Expertise
      • Top Salesforce ConsultantsTop Salesforce Consultants
      • Marketing Cloud ConsultantsMarketing Cloud Consultants
      • Service Cloud ConsultantsService Cloud Consultants
      • Experience Cloud ConsultantsExperience Cloud Consultants
      • Analytics Cloud ConsultantsAnalytics Cloud Consultants
    • Salesforce Industry Expertise
      • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
      • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
      • Health Cloud ConsultantsHealth Cloud Consultants
      • Commerce Cloud ConsultantsCommerce Cloud Consultants
      • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
    • Salesforce Experts by Location
      • USATop Salesforce Consultants in USA
      • IndiaTop Salesforce Consultants in India
      • AustraliaTop Salesforce Consultants in Australia
      • United KingdomTop Salesforce Consultants in UK
      • CanadaTop Salesforce Consultants in Canada
  • Webinars
  • Contact Us
  • Discussions
More options
    Sign in Sign up
    • Blogs
    • Consultants
      • Salesforce Product Expertise
        • Top Salesforce ConsultantsTop Salesforce Consultants
        • Marketing Cloud ConsultantsMarketing Cloud Consultants
        • Service Cloud ConsultantsService Cloud Consultants
        • Experience Cloud ConsultantsExperience Cloud Consultants
        • Analytics Cloud ConsultantsAnalytics Cloud Consultants
      • Salesforce Industry Expertise
        • Non-Profit Cloud ConsultantsNon-Profit Cloud Consultants
        • Financial Service Cloud ConsultantsFinancial Service Cloud Consultants
        • Health Cloud ConsultantsHealth Cloud Consultants
        • Commerce Cloud ConsultantsCommerce Cloud Consultants
        • Manufacturing Cloud ConsultantsManufacturing Cloud Consultants
      • Salesforce Experts by Location
        • USATop Salesforce Consultants in USA
        • IndiaTop Salesforce Consultants in India
        • AustraliaTop Salesforce Consultants in Australia
        • United KingdomTop Salesforce Consultants in UK
        • CanadaTop Salesforce Consultants in Canada
    • Webinars
    • Contact Us
    • Discussions
    Close search

    Activity › Forums › Salesforce® Discussions › SOQL to find Accounts without Contacts AND Opportunities in Salesforce

    Tagged: Account, Dynamic SOQL, Salesforce Customization, SOQL

    • Salesforce® Discussions

      SOQL to find Accounts without Contacts AND Opportunities in Salesforce

      Posted by Radhakrishna on August 21, 2017 at 4:05 AM

      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)

      Shaharyar replied 9 years, 2 months ago 2 Members · 1 Reply
      • Account
      • Dynamic SOQL
      • Salesforce Customization
      • SOQL
    • 1 Reply
    • Shaharyar

      Member
      August 21, 2017 at 5:37 AM

      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.

    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me
    • Public
    • All Members
    • My Connections
    • Only Me

    Popular Salesforce Blogs

    Salesforce Lightning - Two Thumbs Up

    Salesforce Lightning: Two Thumbs Up

    Blog in Lightning

    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…

    Salesforce, Salesforce Consulting LA, Salesforce Development, salesforce develpment company san diego, Salesforce Implementation
    KeyNode Apr 28, 2018
    6,227  Views

    Integrating Salesforce and DevOps to Streamline Your Sales Cycle

    Blog in Others

    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…

    Continuous Delivery, Continuous Integration, CRM Automation Tools, CRM Data Automation, CRM DevOps Integration
    Cloudy Sep 12, 2024
    680  Views

    Why Salesforce Nonprofit Partners Are Essential for Your Organization’s Success

    Blog in Salesforce

    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…

    Automate Processes, Best Practices, Business, Challenges, Configuration
    LevelShift (formerly DemandBlue) Jun 1, 2023
    1,230  Views

    Popular Salesforce Videos

    Salesforce Education Cloud Consultant: Interview Questions

    Salesforce Education Cloud Consultant: Interview Questions

    Video in Salesforce Cloud Platform

    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 Training, Salesforce Tutorial, Salesforce Consultant, salesforce, Salesforce Org
    Rupal Kakkar Apr 18, 2022
    1,951  Views
    Salesforce CRM Full Training Tutorial For Beginners

    Salesforce CRM Full Training Tutorial For Beginners

    Video in Salesforce Training

    In this video, Nick Boardman explains how to use the key features inside Salesforce CRM. He explains various dashboard options, setting up campaigns etc.

    Salesforce Tutorial, salesforce, Salesforce CRM, Salesforce Learning, Tutorial
    Mayra Aug 17, 2022
    3,209  Views
    How to Send a Slack Message from Salesforce Marketing Cloud

    How to Send a Slack Message from Salesforce Marketing Cloud

    Video in Salesforce Training

    In this video, Cameron Robert shows how to use the Slack Message API to send a message from Salesforce Marketing Cloud to a Slack Channel.…

    Salesforce Training, Salesforce Tutorial, salesforce, Salesforce Marketing Cloud, Salesforce Video
    Cameron Jul 25, 2022
    2,432  Views
    Footer Forcetalks logo

    support@forcetalks.com

    • twitterx

    Quick Links

    Advertise with Us

    Salesforce® Articles

    Dreamforce 2023

    Top Salesforce® Bloggers 2023

    Top Salesforce Consultants

    Get Listed

    Company

    Contact Us

    About Us

    Privacy Policy

    Terms & Conditions

    InsightHub

    Salesforce Blogs

    Salesforce Videos

    Salesforce Groups

    Salesforce Jobs

    © 2026 - Forcetalks ● All Rights Reserved

    Salesforce® is a trademark of Salesforce® Inc. No claim is made to the exclusive right to use “Salesforce”. Any services offered within the Forcetalks website/app are not sponsored or endorsed by Salesforce®.

    We use cookies to enhance your browsing experience. Please see our privacy policy if you'd like more information on our use of cookies.