title: LEFT Join not returning records in MS Access
body: <p>My recent project I have a requirements to print receivable summary. I need to return entire rows from the <code>OpeningBalance</code> table and matching rows from <code>VoucherHeader</code> and <code>Customers</code>. </p>
  
  <p>My SQL query is this</p>
  
  <pre><code>SELECT 
      OpeningBalance.OpenID, Sum(OpeningBalance.Amount) AS SumOfAmount,  
      Sum(VoucherHeader.Debit) AS SumOfDebit, Sum(VoucherHeader.Credit) AS SumOfCredit, 
      Customers.CustomerID, Customers.CustomerName 
  FROM 
     (OpeningBalance 
  LEFT OUTER JOIN 
     VoucherHeader ON OpeningBalance.OpenID = VoucherHeader.LedgerID) 
  INNER JOIN 
     Customers ON OpeningBalance.OpenID = Customers.CustomerID
  WHERE 
     (((Customers.CustomerType)='Debtor') 
       AND ((VoucherHeader.VoucherDate)&lt;#2013/06/02#))
  GROUP BY 
      OpeningBalance.OpenID, Customers.CustomerID, Customers.CustomerName, 
      VoucherHeader.LedgerID
  ORDER BY 
      Customers.CustomerName;
  </code></pre>
  
  <p>Please help.</p>