Getting Sum between two dates from two tables broken down by field in one of the tables

I have 3 tables: Table1 - Transactions Table2 - Payments Table3 - Date Table   Relationships: Table1.DocDate <- Table3.Date Table2.PmtDate <- Table3.DATEADD (inactive) Table1.DocNo <-> Table2...