title: PostgreSQL: How to join two tables using between date?
body: <p>I really don't know how to ask this question of mine.</p>
  
  <p>I'll illustrate it using two tables I needed to join.</p>
  
  <h1>TABLE_1</h1>
  
  <pre><code>Name    Date
  John    01-01-2016
  May     04-08-2015
  Rose    10-25-2016
  Mary    12-15-2015
  Ruby    07-07-2017
  </code></pre>
  
  <h1>TABLE_2</h1>
  
  <pre><code>Signatory       DateFrom    DateTo
  President 1     01-01-2015  12-31-2015
  President 2     01-01-2016  12-31-2016
  </code></pre>
  
  <h1>RESULT:</h1>
  
  <pre><code>Name    Date        Signatory
  John    01-01-2016  President 2
  May     04-08-2015  President 1
  Rose    10-25-2016  President 2
  Mary    12-15-2015  President 1
  Ruby    07-07-2017  NULL
  </code></pre>
  
  <p>All I need to check if the <em>Date</em> of <strong>Table_1</strong> is within the <em>DateFrom</em> and <em>DateTo</em> of Table_2 to get the Signatory field.</p>
  
  <p>How I can do that?</p>
  
  <p>Thanks a lot! ^_^</p>