title: how to join table that still retain all values from the main table
body: <p>i got 3 tables but for now i'm only using 2 for testing</p>
  
  <p>AccntTbl   </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>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>and i want the result would look something like this..if in JANUARY</p>
  
  <pre><code>        id     accnt       amount    issued    balance  
        -------------------------------------------------
           1      xxx         10.00     5.00      5.00
           2      yyy         20.00     0.00     20.00
           3      zzz         30.00     0.00     30.00
  </code></pre>
  
  <p>and if it's in FEBRUARY </p>
  
  <pre><code>       id     accnt        amount    issued    balance
        -------------------------------------------------
          1       xxx         10.00     10.00     0.00
          2       yyy         20.00     10.00    10.00
          3       zzz         30.00      0.00    30.00
  </code></pre>
  
  <p>and here's the query that i come up with </p>
  
  <pre><code>       SELECT   AccntTbl.id, AccntTbl.accnt, AccntTbl.amount, 
                  SUM(IssuedTbl.issued) as issued 
         FROM     AccntTbl LEFT JOIN IssuedTbl 
         ON       AccntTbl.id = IssuedTbl.id
         WHERE    (MONTH(IssuedTbl.dateIssue BETWEEN 1 AND 2)) AND
                  (YEAR(AccntTbl.date)= 2016)
         GROUP BY AccntTbl.id, AccntTbl.accnt, AccntTbl.amount
  </code></pre>
  
  <p>but the result is not what i'v been expecting only id from <code>1 &amp; 2</code> would show from the result..i want to show all the values from the AccntTbl with their values from the IssuedTbl..glad from any help..tnx :)</p>