Join Multiple tables with access
<p>I have three tables in Access database. <code>CheckDJ</code> and <code>CashDJ</code> has more columns than <code>CashRJ</code>. I would like to merge those tables into one. I have the following query:</p>

<pre><code>SELECT
    a.acctname,
    a.code,
    (
        sum(a.debit) + sum(b.debit) + sum(c.debit)
    ) AS DebitTotal,
    (
        sum(a.credit) + sum(b.credit) + sum(c.credit)
    ) AS CreditTotal
FROM
    (
        CheckDJ a
        LEFT OUTER JOIN CashRJ b ON a.id = b.id
    )
LEFT OUTER JOIN CashDJ c ON a.id = c.id
GROUP BY
    a.acctname,
    a.code
</code></pre>

<p>Problem is, the code above only display the similar data with <code>CheckDJ</code>. Can anyone help me? Thank you in advance!</p>