title: joining multiple tables with filter by date
body: <p>i got 3 tables..how do i join these tables with filter by date on each table</p>
  
  <p>MainTbl</p>
  
  <pre><code> id    accnt   amount    date
  ---------------------------------
    1      xxx     10.00   1/1/2016
    2      yyy     20.00   1/1/2016
    3      zzz     30.00   1/1/2016
  </code></pre>
  
  <p>SupplyTbl - this table would add the value of supply to the amount in the MainTbl</p>
  
  <pre><code>  id   accnt    supply   date
  -------------------------------
     1     xxx     5.00     1/10/2016
     1     xxx     5.00     2/14/2016
     2     yyy    10.00     1/20/2016
  </code></pre>
  
  <p>IssuedTbl</p>
  
  <pre><code>  id   accnt    issued   dateIssue
  ------------------------------------------
     1     xxx    5.00      1/10/2016
     1     xxx    5.00      2/14/2016
     2     yyy   10.00      2/15/2016  
  </code></pre>
  
  <p>now i want to join these tables..with date range..if i filter the date to <code>JANUARY</code> it would result something like this </p>
  
  <pre><code>  id   accnt  amount   issued
   -----------------------------
    1     xxx    15.00    5.00
    2     yyy    30.00    0.00
    3     zzz    30.00    0.00
  </code></pre>
  
  <p>and when i filter to <code>FEBRUARY</code>..it will combine both from <code>JANUARY</code> to <code>FEBRUARY</code></p>
  
  <pre><code> id   accnt  amount   issued
   -----------------------------
    1     xxx    20.00   10.00
    2     yyy    40.00   10.00
    3     zzz    30.00    0.00
  </code></pre>
  
  <p>i'm struggling with this since the other night..glad with any help..tnx in advance :)</p>