title: oracle sql - Select ONLY if there are NO null values in that column
body: <p>I am looking at a checklist that contains several unique checklist items.  I only want to select records (ID, name, etc) of those who have NO null values in the checklist date field.</p>
  
  <pre><code>Select distinct sp.id as "ID",
                  SP.LAST_NAME as "Last",
                  SP.FIRST_NAME as "First",
                  SA.TERM_CODE_ENTRY as "Term", 
                  SA.APST_CODE as "Status"
  FROM SPRITE SP
  JOIN SARC CK
      on sp.sprite_pidm = CK.SARC_pidm 
  JOIN ADAP SA
      on sp.sprite_pidm = sa.adap_PIDM
  WHERE
      Sp.sprite_change_ind is null
  and SA.ADAP_TERM_CODE_ENTRY = '201480'
  and SA.ADAP_APST_CODE = 'I'
  and SA.ADAP_APPL_NO  = CK.SARC_APPL_NO
  -- where there are no null records - all records should be not null
  and CK.SARC_RECEIVE_DATE is not null
  </code></pre>
  
  <p>Currently, it is selecting those who have at least one not null checklist date.  This means it is still selecting records of those who have null dates for some checklist items.</p>
  
  <p>How do tell it to select where
  CK.SARC_RECEIVE_DATE = (all checklist item receive_dates must be non-null values)?</p>
  
  <p>Simplified Example:</p>
  
  <pre><code>ID    Name    Checklist Items    DateReceived       Other data...
  01    Sherry  missing item 1     
  01    Sherry  missing item 2     02-02-14
  05    Mike    missing item 8     02-03-13
  17    Carl    missing item 2     
  17    Carl    missing item 3     
  28    Luke    missing item 3     04-03-13    
  28    Luke    missing item 5     04-03-13
  28    Luke    missing item 8     04-03-13
  
  The results should be
  05    Mike (other data...)
  28    Luke (other data...)
  
  Instead, it is returning
  01    Sherry (other data...)
  05    Mike   (other data...)
  28    Luke   (other data...)
  </code></pre>