title: sql removing multiple records with mutltiple date values
body: <p>I have the following sample data that I need to clean the records by specific date.  For this example, lets use anything older than march 2012 will need to be removed along with other related records.</p>
  
  <p>Author Table</p>
  
  <pre><code>    Author       Book     date
  -------------------------------------
      Smith        Bk1      01/01/2012
      Smith        Bk2      02/01/2012
      Smith        Bk3      02/25/2012
      Johnson      Bk1      06/01/2011
      Johnson      Bk2      09/01/2011
      Johnson      Bk3      03/01/2012
      Johnson      Bk4      01/01/2013
      Jones        BK1      01/01/2001
      Jones        BK2      01/01/2002
      Jones        BK3      01/01/2009
      Jones        BK4      08/01/2013
  </code></pre>
  
  <p>There is also a Book table</p>
  
  <pre><code>    Author       Book     info
  -------------------------------------
      Smith        Bk1      asdfadf
      Smith        Bk2      asdfasdf
      Smith        Bk3      asdfadf
      Johnson      Bk1      asdfadf
      Johnson      Bk2      adsfasdf
      Johnson      Bk3      asdasdf
      Johnson      Bk4      asdfasdf
      Jones        BK1      asdfasdf
      Jones        BK2      adsfasdf
      Jones        BK3      adsfasdf
      Jones        BK4      adsfasdf
  </code></pre>
  
  <p>Above is the data set.  So if the Author has a book in the table that is older than 03/01/2013, then All of the records need to be removed. If they have at least one Book newer than the date specified then All records are kept.  In this scenario, the Jones records are the only ones to be kept in the table data set.  Once we figure which Author has been filtered then we would remove the records from the Book table, and then the Author table.</p>
  
  <p>Thanks for any help, I appreciate it.</p>