SELECT JournalEntries.JournalEntryID, Accounts.ListID, JournalEntryTrans.Debit, JournalEntryTrans.Credit, JournalEntries.[Date]
FROM JournalEntries
INNER JOIN JournalEntryTrans ON JournalEntries.JournalEntryID = JournalEntryTrans.JournalEntryID
LEFT JOIN Accounts ON JournalEntryTrans.AccountID = Accounts.AccountID
WHERE JournalEntries.CompanyID = 1
AND JournalEntries.[Date] > '2007-04-30'
AND JournalEntries.[Date] <= '2007-05-01'
AND JournalEntries.TxnID IS NULL
ORDER BY JournalEntries.JournalEntryID, JournalEntryTrans.JournalEntryTransID


JournalEntries: 2 Rows
JournalEntryTrans: 42 Rows
Accounts: 122 Rows