title: SQL Query to generate Employee absent report for a given range of dates
body: <p>I Have two tables Master(empname,empid) which consists of all the employees and another table Transaction(empid,Presentdate) which gives the dates and which employee was present.<br>
  How do i find the list of absentees within a certain range of dates</p>
  
  <p>I've tried the below Sql Query</p>
  
  <pre><code>SELECT empid FROM Master 
  where empid NOT IN(select empid  from  Transaction 
  where Date(Presentdate) between '2012-11-21' and '2012-12-22')
  </code></pre>
  
  <p>which returns only the employee  id's who were absent,I want to display the employee's absent dates also</p>
  
  <p>Note(Transaction table stores only the employee's present dates)</p>
  
  <p><strong>If an employee is absent then Entire record will not be inserted into the Transaction table</strong></p>