多表联合查询的有关问题《多表联合查询的有关问题

多表联合查询的问题《多表联合查询的问题？
select a.corp_id,a.corp_name,(select sum(b.sale_money) from x_sale sale_corp=a.corp_id)as salemoney,(select sum(b.saleout_money) from x_saleout saleout_corp=a.corp_id)as saleoutmoney,这里怎么写才可以salemoney和saleoutmoney 相减 from x_kcorp a



[解决办法]

SQL code

select   a.corp_id,  a.corp_name,  b.salemoney,  c.saleoutmoney,  b.salemoney-c.saleoutmoneyfrom x_kcorp ajoin (select sale_corp,sum(sale_money) as salemoney from x_sale group by sale_corp) b  on a.corp_id=b.sale_corpjoin (select saleout_corp,sum(saleout_money) as saleoutmoney from x_saleout group by saleout_corp) c  on a.a.corp_id=c.saleout_corp
[解决办法]
SQL code
use CSDNgo--#1.直接减就可以select     a.corp_id,    a.corp_name,    (select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) as salemoney,    (select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id) as saleoutmoney,    diff = (select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) - (select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id)from x_kcorp a--#2.或者用子查询select     *,    diff = salemoney - saleoutmoneyfrom(    select         a.corp_id,        a.corp_name,        (select sum(b.sale_money) from x_sale where sale_corp=a.corp_id) as salemoney,        (select sum(b.saleout_money) from x_saleout where saleout_corp=a.corp_id) as saleoutmoney    from x_kcorp a) T