title: SQL How to display data before a certain date
body: <p>I have a couple of tables. One is a <strong>worker table</strong> which displays worker code, firstname and lastname. 
  <strong>Job dates</strong> which shows worker code, date of job start, end and job area code.
  <strong>Supervisor</strong> has worker number, firstname, surname and job area code.
  <strong>Job area</strong> has job area code name and supervisor.</p>
  
  <p>What I'm trying to do is display the worker code before date 10/09/10
  Since I am new to this, I'm trying to do it all written and theory first before making the database.</p>
  
  <p>Does this sound right? I'm not too sure about the date thing.</p>
  
  <pre><code>select worker
  From Job Dates
  where job start &lt; '10/09/10'
  </code></pre>
  
  <p>In theory this sounds right to me, but does it somehow need to tell the query it is a date stamp?</p>
  
  <p>I then want to find the surname of workers and the surnames of their supervisor if the workers started the job before the 10/09/10? I'm guessing this will be with a JOIN?</p>
  
  <p>Thanks</p>