SELECT tblTransactions.TransactionDate, tblTransactions.TransactionDescription, tblTransactionDebits.DebitAmount, tblTransactionCredits.CreditAmount, tblAccounts.AccountName
FROM ((tblTransactionDebits INNER JOIN tblTransactions ON tblTransactionDebits.TransactionID=tblTransactions.TransactionID) INNER JOIN tblTransactionCredits ON tblTransactions.TransactionID=tblTransactionCredits.TransactionID) 
LEFT JOIN tblAccounts ON tblTransactionCredits.AccountID=tblAccounts.AccountID
LEFT JOIN tblAccounts ON tblTransactionDebits.AccountID=tblAccounts.AccountID;