这应该使您接近：
select cat_name, sum(exp.exp_amount)from (select exp_cat_id, exp_amount from cash_expenses union all select exp_cat_id, exp_amount from cheque_expenses) as expinner join exp_cat on exp.cat_id = exp_cat.cat_idgroup by cat_name;
这应该使您接近：
select cat_name, sum(exp.exp_amount)from (select exp_cat_id, exp_amount from cash_expenses union all select exp_cat_id, exp_amount from cheque_expenses) as expinner join exp_cat on exp.cat_id = exp_cat.cat_idgroup by cat_name;
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
