title: How to find missing data in a range of dates in oracle sql
body: <p>I have table (ATTENDANCE) contains the attendance of the employee as following </p>
  
  <pre><code>EMPNO   DATE
  2     07/11/2016
  2     07/12/2016
  3     07/12/2016
  6     07/13/2016
  7     07/13/2016
  </code></pre>
  
  <p>which contains the employee number(empno) and the attended date(date)</p>
  
  <p>And another table (EMPLOYEES) contains all the empolyees in the company for example like this</p>
  
  <pre><code>EMPNO   NAME
  1       Musa
  2       Ali 
  3       Khalid
  6       James
  7       Sara
  </code></pre>
  
  <p>I can find if an employee was absent in a specific date by using this code </p>
  
  <pre><code>select empno 
  from EMPLOYEES 
  where empno not in (select empno 
                 from ATTENDANCE
                 where date = '07/11/2016')
  </code></pre>
  
  <p>I want to retreive the list of absent employees in any day between a specific range<br>
  I tried to use this query </p>
  
  <pre><code>select empno 
  from EMPLOYEES 
  where empno not in (select empno 
                 from ATTENDANCE
                 where  date between '07/11/2016' and  '07/13/2016'  )
  </code></pre>
  
  <p>but this will give me those who are absent in <strong>all</strong> the days in this range , <strong>If an employee was absent in one day only it will not retreive it</strong></p>
  
  <p>I want a query to retreive the empno and the date where the employee was absent?</p>
  
  <p><strong>Update:</strong>
  I tried this too , as <strong>sagi</strong> mentioned</p>
  
  <pre><code>select empno 
  from EMPLOYEES 
  where empno not in (select empno
      from ATTENDANCE
      group by empno
      having count(empno) = to_date(' 07/09/2016','mm,dd,rrrr') - to_date('07/13/2016','mm,dd,rrrr') )
  </code></pre>
  
  <p>this will work but it will not give me in <strong>which date the employee was absent</strong> </p>