title: ORACLE SQL Query records where date falls between minimum and maximum date from other table
body: <p>In TABLE_A there is for each ID a minimum SDT and maximum EDT.</p>
  <blockquote>
  <p>Example: for ID=1000 this will be 1/09/2013 and 3/10/2013.</p>
  <p>Example: for ID=1001 this will be 1/07/2013  and 3/08/2013.</p>
  </blockquote>
  <p>The expected result will be all records from TABLE_B where the SDT from TABLE_B falls between those minimum SDT and maximum EDT values from TABLE_A.</p>
  <p><a href="http://www.sqlfiddle.com/#!4/a196f4" rel="nofollow noreferrer">Example Fiddle</a></p>
  <p><strong>TABLE_A</strong></p>
  <pre><code>ID      SDT          EDT
  ------------------------------
  1000    1/10/2013    3/10/2013  
  1000    1/09/2013    3/09/2013   
  1001    1/08/2013    3/08/2013
  1001    1/07/2013    3/07/2013
  1002    1/06/2013    3/06/2013
  </code></pre>
  <p><strong>TABLE_B</strong></p>
  <pre><code>ID      SDT
  -----------------
  1000    2/10/2013   ===&gt; because it falls between 1/09/2013 and 3/10/2013
  1000    4/09/2013   ===&gt; because it falls between 1/09/2013 and 3/10/2013
  1001    2/08/2013   ===&gt; because it falls between 1/07/2013  and 3/08/2013
  1001    4/05/2013   ==&gt; not in result because it's not between 1/07/2013 and 3/08/2013
  1002    4/06/2013   ==&gt; also out of range, so not in results
  </code></pre>