title: Need SQL Query to find Parent records without child records
body: <p>I am not at all conversant in SQL so was hoping someone could help me with a query that will find all the records in a parent table for which there are no records in a child table. </p>
  
  <p>The following works for me to find parent records for specific child field values...</p>
  
  <pre><code>`SELECT    ParentTable.ParentID
   FROM      ParentTable INNER JOIN
               ParentTable ON ParentTable.ParentID = ChildTable.ChildID
   WHERE     (ChildTable.ChildField_ = '2131')
   Group By
     ParentTable.ParentID
   Having
     count(distinct ChildTable.ChildField) &gt; 0`
  </code></pre>
  
  <p>Can I change the where clause some how to find parent's with a count of zero child records.</p>
  
  <p>Thanks.</p>