使用LEFT JOIN 统计左右存在的数据( 二 ) _生活百科

select tc.id,tc.name,ta.id as account from t_company tc left join t_account ta on 1 = 1idnameaccount1腾讯11腾讯22百度12百度2查询出所有的公司账套之后，再left join收款表和发票表:
select tc.id,tc.name,tc.account,tc2.amount as collection_amount,ti.amount as invoice_amunt from (select tc.id,tc.name,ta.id as account from t_company tc left join t_account ta on 1 = 1)tcleft join ( select company_id,account,sum(amount) as amount from t_collection group by company_id,account) tc2 on tc.id = tc2.company_id and tc.account = tc2.accountleft join ( select company_id,account,sum(amount) as amount from t_invoice group by company_id,account) ti on tc.id = ti.company_id and tc.account = ti.account结果：
idnameaccountcollection_amountinvoice_amunt1腾讯130101腾讯220202百度130302百度24050总结