title: How to write a complex master-detail query in T-SQL
body: <p><br/>I need some help getting a SQL query running the way I need. I know you sql gurus will be laughing at this, but I really don't know how to do this :-(<br/>
  I have two tables in a MS-SQL database. One is <strong>workers</strong>, the other is <strong>contracts</strong>. They are in a 1-to-many relationship, that is one worker can have zero or more contracts.<br/>
  There was a change in the contract and all the workers were requested to sign new contracts.
  What I need to get is all the workers who HAVE NOT yet signed a new contract. That is who do not have a contract after a certain date. I tried using left outer join, but it didn't work :-(<br/></p>
  
  <p>These are the key columns in the tables:<br/></p>
  
  <p><strong>Workers:</strong><br/>
  WorkerID<br/>
  FirstName<br>
  LastName<br>
  ...   </p>
  
  <p><strong>Contracts:</strong><br>
  ContractID<br>
  Date<br>
  WorkerID<br>
  Amount<br>
  ...  </p>
  
  <p>Any help is greatly appreciated.<br>
  Thanks.<br>
  Trex</p>