title: SQL Query To Get All Records From One Table, Except A Specific Record, By Date, From Another Table
body: <p>I am trying to SELECT records from two MySql tables.  I would like all records from the first table excluding specific records, by date, from the second table.  For example:</p>
  
  <p><strong>Table1</strong> <code>T1id</code>, <code>firstName</code>, <code>LastName</code> <br>
  <strong>Table2</strong> <code>id</code>, <code>T1id</code>, <code>hours</code>, <code>rate</code>, <code>date</code></p>
  
  <p><code>T1id</code> is the link between the two tables, therefore when the tables are joined I would have <code>T1id</code>, <code>firstName</code>, <code>lastName</code>, <code>hours</code>, <code>rate</code>, <code>date</code></p>
  
  <p>Let's say there is a record in <strong>Table2</strong> with a <code>date</code> of 2012-02-08.  With one query, I need to select all records from <strong>Table1</strong>, <strong><em>excluding the record from Table2 that has the date of 2012-02-08</em></strong>.</p>
  
  <p>I've tried a few variations of JOINS and UNIONS, however I either get all records, a bunch of duplicate records, or one record (i.e. Table2 date).  I apologize, but I do not have a specific piece of code to include since nothing has worked for me. </p>