--
我有另一个场景，其中贷方日期、借方日期和贷款日期可以相同。输出表有以下列
日期：应结合贷方日期、借方日期和贷款日期（贷方日期、借方日期和贷款日期也可以相同或不同）

**贷记付款：**查找给定贷记日期、实体、货币、所有者的贷记金额之和

借方付款：查找给定借方日期、实体、货币、所有者的借方金额之和
贷款支付：查找给定贷款日期、实体、货币、所有者的贷款金额之和，
实体：表1中的值
货币：表1中的值
所有者：表1中的值
合计：贷方付款+借方付款+贷款付款之和
请你带路好吗。
请查看以下截图。

在联合所有列之前，可能需要显式指定空列：

insert into table2 
select *
from (
    select credit_date as date, sum(credit_amount) as credit_payment, null as debit_payment, null as loan_payment
    from table1
    group by credit_date
    union all
    select debit_date as date, null as credit_payment, sum(debit_amount) as debit_payment, null as loan_payment
    from table1
    group by debit_date 
    union all
    select loan_date as date, null as credit_payment, null as debit_payment, sum(loan_amount) as loan_payment
    from table1
    group by loan_date
) t
order by date;